FireDAC.Stan.Option.TFDFetchOptions.RecsSkip
Delphi
property RecsSkip: Integer read GetRecsSkip write SetRecsSkip
C++
__property int RecsSkip = {read=GetRecsSkip, write=SetRecsSkip, stored=IsESS, default=-1};
Properties
| Type | Visibility | Source | Unit | Parent |
|---|---|---|---|---|
| property | published | FireDAC.Stan.Option.pas FireDAC.Stan.Option.hpp |
FireDAC.Stan.Option | TFDFetchOptions |
Description
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. To change RecsSkip for an already prepared dataset, the application must call the Disconnect method first.
FireDAC discards the first RecsSkip records and returns records, starting from the RecsSkip+1 record. The <= 0 value means - do not skip. Combining the RecsSkip and RecsMax properties allows you to implement a result set paging, useful for the web applications. Also, an application can use the LIMIT escape function. If both are specified, then the LIMIT has a higher priority.
Depending on a DBMS, RecsMax and RecsSkip can 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.