Page 1 of 1

error TZReadOnlyQuery with MYsql Variables in Delphi5

Posted: 18.09.2007, 10:20
by KAYAALP
hello everybody,
i want to execute this sql (MySql 4.0x) with TZReadOnlyQuery id Delphi5

SELECT @n := @n+1 AS rownum, thing, arms, legs FROM limbs

but i get this error : "incorrect token followed by ':'"

i think that, the sql parser looks for a parameter after the ':'
how can i solve the problem?

Posted: 18.09.2007, 14:42
by mdaems
Set ParamCheck Property to 'False'. The query will not be scanned for ':'.

Mark

Posted: 19.09.2007, 07:26
by KAYAALP
thank you so much