Been fiddling with the Oracle connector. This: using the scott schema on Oracle 10g, this works fine in my JDBC query GUI and in sql*plus: select * from scott.emp where JOB='CLERK';
However, in code (FPC trunk x86, Windows), this: Q.SQL.Text:='select * from EMP WHERE JOB=''CLERK'';'; gives ORA-00911: invalid character!?!? (with the 11g instant client) What am I doing wrong? Program can be downloaded here: https://bitbucket.org/reiniero/fpc_laz_patch_playground/downloads/dberror.lpr [1] If you're not a Terry Pratchett fan, never mind... _______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal