error TZReadOnlyQuery with MYsql Variables in Delphi5

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
KAYAALP
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 18.09.2007, 09:49

error TZReadOnlyQuery with MYsql Variables in Delphi5

Post 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?
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

Set ParamCheck Property to 'False'. The query will not be scanned for ':'.

Mark
KAYAALP
Fresh Boarder
Fresh Boarder
Posts: 4
Joined: 18.09.2007, 09:49

Post by KAYAALP »

thank you so much
Post Reply