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.