Zeoslib Portal

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

Hello,

Use a TZSQLProcessor component to run multiple SQL statements.

Bye,

Josimar

Hello,

the other solution is to change the SQL to: That should increase the speed of your application.

Good luck!