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 (including 0). Rows from table are fetched starting from Offset row.
Example:
Limit := 100;
Offset := 100;
Query is prepared for fetching 100 rows starting with row number 100.
Setting Offset is meaningless without setting Limit property either. Default Limit value -1 will produce syntax error in other case.