roeya
Posts: 181
|
Posted: 12/04/2008, 1:02 PM |
|
Firebirds LIMIT syntax is as follows:
SELECT FIRST 20 SKIP 100 * FROM TABLE
it will select records 100 - 119 form a query
the default interbase support does not support this syntax so -
I changed Components/Databases/Interbase.xml
change line 22 from
topRecordsSyntax=""
to:
topRecordsClause=" FIRST {SqlParam_numRecords} SKIP {SqlParam_Offset}"
topRecordsSyntax="Limit"
topRecordsPlace="beforeFrom"
close CCS open it again
eanble the Top/Limit check box in the connection proerties and regenerate your project
Important for grids with Data source type = SQL you must manually add
FIRST {SqlParam_numRecords} SKIP {SqlParam_Offset} for the query or it will not work
_________________
http://www.infoneto.com/ |
|
|
|