Hello, Am 17.03.2011 21:20, schrieb Sibylle Koczian: > > I've got it and will try it out. But that will take time and some > questions on this list. >
I've changed the part for getting the right connection data: now the application asks for a connection file, the connection name and the crypto key. It works for PostgreSQL and SQLite, but doesn't work for Firebird. 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? Greetings Sibylle _______________________________________________ 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/4d8e186e.6020...@t-online.de
