Zsqlprocessor1 error commit work

[Dfox]

Error commit work; in firebird SQL script

[marsupilami]

Hello,

could you please try to create a sample project that shows the error? I use Firebird on a daily basis with TZSQLProcessor and for me it works.

Best regards,

Jan

[Dfox]

do the following and put it at the end of the firebird sql script
commit work;

[Dfox]

exemple

Code: Select all

update table set id = 1;
commit work;

[marsupilami]

You are not supposed to use commit in the script.

Call TZConnection.Commit after you executed the script successfully.

[Dfox]

OK thanks