[Lazarus] Params in ZeosDBO not working

Joost van der Sluis joost at cnoc.nl
Sun May 24 15:27:17 CEST 2009


Op vrijdag 15-05-2009 om 15:32 uur [tijdzone +0700], schreef dayat:
> I'm using fpc 2.2.4, lazarus 0.9.26.2, zeosdbo 6.6.3-stable. I'm
> executing sql commands in TZSQLProcessor using params for changing the
> values. The sql sintax like "INSERT INTO TABLE1
> VALUES(:PAR1, :PAR2);". The property of ParamCheck filled with the
> True value, and when I executing the sql I'm got the error. 

Maybe you can better ask on the ZEOS-forum

> After checking, I found that values in SQL sintax can't to change, the
> sql sintax still such "INSERT INTO TABLE1 VALUES(:PAR1, :PAR2);".
> Finally I must executing manually such "INSERT INTO TABLE1 VALUES(" +
> edit1.text +","+ edit2.text +");".

That is normal. A parameter is not something that is replaced by the
client with something else, it's send seperately to the server.

Joost.






More information about the Lazarus mailing list