Syntax error - Multiple commands

[doidopb]

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

[josimarz]

Hello,

Use a TZSQLProcessor component to run multiple SQL statements.

Bye,

Josimar

[Wild_Pointer]

Hello,

the other solution is to change the SQL to:

Code: Select all

UPDATE SCE2_ESTQUIMI SET quant_nf = quant_nf + 1 WHERE codigo IN (200, 201, 202)

That should increase the speed of your application.

Good luck!