Recordset
The ODBC recordset is the set of records from the datasource. If no filter is present, it encompasses the whole datasource. If a filter is present, it is only the subset of records for which the filter condition is satisfied.
A filter is made up of a condition and a parameter that the '?' in the condition stands for. Some examples :
| condition (filter) | paramter | result : only records |
| NAME like ? | du* | whose NAME starts with "du" |
| GROUP = ? | 501 | whose GROUP = 501 |
| NAME < ? | d | whose first character in NAME is after 'd' |
The result can be sorted.