Page 1 of 1
Zsqlprocessor1 error commit work
Posted: 02.06.2024, 17:16
by Dfox
Error commit work; in firebird SQL script
Re: Zsqlprocessor1 error commit work
Posted: 03.06.2024, 10:13
by 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
Re: Zsqlprocessor1 error commit work
Posted: 03.06.2024, 16:58
by Dfox
do the following and put it at the end of the firebird sql script
commit work;
Re: Zsqlprocessor1 error commit work
Posted: 04.06.2024, 01:14
by Dfox
exemple
Code: Select all
update table set id = 1;
commit work;
Re: Zsqlprocessor1 error commit work
Posted: 04.06.2024, 12:36
by marsupilami
You are not supposed to use commit in the script.
Call TZConnection.Commit after you executed the script successfully.
Re: Zsqlprocessor1 error commit work
Posted: 05.06.2024, 00:52
by Dfox
OK thanks