Seems Servoy 3.5rc2 is assuming that us developers don’t terminate their SQL properly with a semicolon and can simply add ’ limit ?’ to the query.
This is my code:
forms.rss_boeking_edit_new.controller.loadRecords("SELECT rss_boeking.bkg_id FROM rss_boeking WHERE bkg_id=? ORDER BY bkg_id;", [bkgID]);
Wich results in the following error:
2007-06-08 17:01:02,849 ERROR [AWT-EventQueue-0] com.servoy.j2db.util.Debug - select bkg_id from rss_boeking where bkg_id=? order by bkg_id; limit ?
org.postgresql.util.PSQLException: ERROR: syntax error at or near "limit"
at org.postgresql.core.v3.QueryExecutorImpl.receiveErrorResponse(QueryExecutorImpl.java:1525)
at org.postgresql.core.v3.QueryExecutorImpl.processResults(QueryExecutorImpl.java:1309)
etc..