Controls the offset of the first record to be fetched.
Use RecsSkip to specify the number of records to skip from the beginning of a single result set.
AnyDAC discards RecsSkip first records and returns records, starting from RecsSkip+1 record number. The <= 0 value means - do not skip.
Combining the RecsSkip and the RecsMax properties allows to implement a result set paging, useful for the web applications. Also an application may use the LIMIT escape function. If both are specified, then the LIMIT has a more high priority.
Depending on a DBMS, the RecsMax and RecsSkip may be translated to a SELECT statement clause (TOP, LIMIT, etc) limiting a result set on a server side. If a DBMS does not support such clauses, then limiting will be performed on a client.
The default value is -1.
property RecsSkip: Integer;
ADQuery1.FetchOptions.RecsMax := 20; ADQuery1.FetchOptions.RecsSkip := 60; ADQuery1.Open; ADQuery1.FetchAll; // query will return records from 61'th to 80'th
What do you think about this topic? Send feedback!