Wt

I have changed a little class Query to allow processing of Firebird 2.1 (and up). The change is about to be limit and offset select statement.

In Firebird 2.1 (and up) you have to use ROWS statement like:

select * from mir_something rows 1 to 20

ROWS A TO B (where A > 0 and B > 0).

Typical change would be to allow Query to use ROWS instead limit and offset. For example simply add a method:

  void useROWSInSELECT(bool queryIsUsingROWS);

and then use SELECT with ROWS subclause if queryIsUsingROWS == true (otherwise use limit and offset).

Subclassing would be a little overhead.

BR,

Łukasz Matuszewski