Zeoslib Portal

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?

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

or set checkparam = false in property of component (TZReadOnlyQuery)

thank you so much

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

Its not working in delphi 7, mysql 5.1 and zeos 6.6.6
how to use it in delphi 7?

or set checkparam = false in property of component (TZReadOnlyQuery)

I can't do this. cuz I have another params in query also.

could somebody help?

I'm afraid I only have a solution in zeos7 : there you can set another parameter character instead of ':'

Mark