Collapse All
AnyDAC
ContentsIndexHome
PreviousUpNext
TADFetchOptions.RecsSkip Property
TADFetchOptions Class  TADFetchOptions Members  uADStanOption Namespace  Example  published  See Also  Send Feedback

Controls the offset of the first record to be fetched.

Group

published

Links
TADFetchOptions Class, TADFetchOptions Members, uADStanOption Namespace, Example, published, See Also
Description

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.

Syntax
property RecsSkip: Integer;
See Also
Example
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!