Użytkownik Sibylle Koczian napisał:
> As far as I can see at the moment it's the LIMIT clause added to the
> SQL. Firebird uses SELECT FIRST x SKIP y<rest of query> (or with new
> versions SELECT<rest of query> ROWS y+1 TO y+x) instead. If a Dabo
> application uses a normal dBizobj this is no problem, the usual "LIMIT
> 1000" addition is changed to "FIRST 1000" and this clause is put into
> its correct place.
>
> But the createreport script uses dConnection.getDaboCursor() and that
> doesn't seem to do this adaptation. Using a Firebird connection it
> crashes with exactly the same error message I get from FlameRobin if I
> try to execute a query with "LIMIT x" directly.
>
> I'll try to find out more about this, but perhaps somebody else has good
> advice?
>
>
Hi.
You mean that cursor.setLimitClause("1000") doesn't work?
Regards
Jacek Kałucki
_______________________________________________
Post Messages to: Dabo-users@leafe.com
Subscription Maintenance: http://leafe.com/mailman/listinfo/dabo-users
Searchable Archives: http://leafe.com/archives/search/dabo-users
This message: http://leafe.com/archives/byMID/4d8e1ff2.8040...@rz.onet.pl
