Obj.dbSelectExactSQL = "SQL text with optional [[PageTop]], [[PageSize]] or [[Top]] macros"
x.dbSQL = "SELECT * from EMPLOYEE fetch first [[Top]] rows only"
x.dbSQL = "SELECT * from MYSQLTEST [[PageTOP]], [[PageSize]]"
x.dbSQL = "SELECT TOP [[Top]] from Authors"
Remarks
[[PageTop]] and [[PageSize]] holds the start record and offset of records and is filled in by system. This is the most efficient select SQL as it retrieves the exact amount of records for display. It is inefficient for example to retrieve the entire recordset just to display records 5 to 10.
For those DBs that do not have such SQL capabilities like MS-SQL. The next best way to be efficient is to retrieve [[Top]] records in order to include the display records. Example is to retrieve 100 records just to get display rcords 95-100. In this case, use the [[Top]] macro.