Show: Delphi C++
Display Preferences

FireDAC.Stan.Option.TFDFetchOptions.RecsSkip

From RAD Studio API Documentation
Jump to: navigation, search

Delphi

property RecsSkip: Integer read GetRecsSkip write SetRecsSkip  stored IsESS default -1;

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.

See Also

Personal tools
RAD Studio 10.2 Tokyo
In Other Languages
Previous Versions
Assistance