On 3-12-2012 17:17, Tomas Hajny wrote: > On Mon, December 3, 2012 16:44, Reinier Olislagers wrote: >> 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 > > I don't know what you're doing wrong, but I'd try excluding the semicolon. > Thanks, Tomas, did that already - no effect.
_______________________________________________ fpc-pascal maillist - fpc-pascal@lists.freepascal.org http://lists.freepascal.org/mailman/listinfo/fpc-pascal
