From RAD Studio API Documentation
Jump to: navigation, search


property RecsSkip: Integer read GetRecsSkip write SetRecsSkip


__property int RecsSkip = {read=GetRecsSkip, write=SetRecsSkip, stored=IsESS, default=-1};


Type Visibility Source Unit Parent
property published
FireDAC.Stan.Option TFDFetchOptions


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.

See Also