Can I use an "IN" filter on an Advantage Database Table (TAdsTable)?
- by Anthony
I want to apply a filter to an advantage table using multiple values for an Integer field.
The equivalent SQL would be:
SELECT * FROM TableName WHERE FieldName IN (1, 2, 3)
Is it possible to do the same on an AdsTable within having to repeat the field using an "OR"?
I want to something like:
Filter := 'FieldName IN (1, 2, 3)'
Instead of:
Filter := 'FieldName = 1 OR FieldName = 2 OR FieldName = 3'