How can I search on different values in one field?

Classic Servoy
1

I have a field that I want to search on…

I want to search a number of values, examples are:

10, 20,21,22,23,24,25,26,27,28,30

In other words the value 10 and 20 - 30…

Can I search on these values in one with find/search or do I need an SQL statement.

If the last one is the case can I then put the results of the sql into a foundset?

Thanks…

2

This is clearly explained in the manual:

controller.find()
youreNumber = 10;
controller.newRecord();
youreNumber = 20…30;
controller.search()