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