Specifies the row number from which data to be fetched from table.

Syntax:

property Offset: Integer .... default 0;

Description:

Query is prepared for fetching not more than Limit rows. Rows from table are fetched starting from Offset row.

Example:

Limit  := 0;
Offset := 100;

Query is prepared for fetching all rows starting with row number 100.