Syntax error - Multiple commands

Forum related to MySQL

Moderators: gto, cipto_kh, EgonHugeist

doidopb
Fresh Boarder
Fresh Boarder
Posts: 9
Joined: 01.12.2012, 19:52

Syntax error - Multiple commands

Postby doidopb » 30.07.2013, 15:13

Hi,

I use the zeos 6.6.2-RC, Delphi 7 and Mysql 5.0.45. I'm trying to run multiple commands at once, example:

z_command.SQL.add('UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + ' + 1 WHERE codigo = "200";');
z_command.SQL.add('UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + ' + 1 WHERE codigo = "201";');
z_command.SQL.add('UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + ' + 1 WHERE codigo = "202";');

z_command.ExecSQL;

Does not work, I get an error SQL Syntax, but HeidiSQL the functions normally.

Does anyone know how to do???

Thanks

User avatar
EgonHugeist
Zeos Dev Team
Zeos Dev Team
Posts: 1739
Joined: 31.03.2011, 22:38

Postby EgonHugeist » 30.07.2013, 21:14

doidopb,

why are you using this old version? update to 7.0 and we can check the issues. 6.x isn't maintained anymore, since we miss some more volunters for coding.
King regards, Michael

You want to help? viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/

Image

marsupilami
Gold Boarder
Gold Boarder
Posts: 660
Joined: 17.01.2011, 14:17

Postby marsupilami » 01.08.2013, 16:52

Hello doidopb,

first issue - upgrade to 7.0 if you can, as Michael suggests. If you can not upgrade, upgrade to Zeos 6.6.6. Also please post the error message because these contain valuable information at most times...
Best regards,

Jan


Return to “MySQL”

Who is online

Users browsing this forum: No registered users and 1 guest