Zsqlprocessor1 error comment in end scrit

The offical for ZeosLib 7.3 Report problems, ask for help, post proposals for the new version of Zeoslib 7.3/v8
Quick Info:
-We made two new drivers: odbc(raw and unicode version) and oledb
-GUID domain/field-defined support for FB
-extended error infos of Firebird
-performance ups are still in queue
In future some more feature will arrive, so stay tuned and don't hassitate to help
Post Reply
Dfox
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: 24.03.2024, 23:41

Zsqlprocessor1 error comment in end scrit

Post by Dfox »

Zsqlprocessor1 error when commenting at the end of the script
example

Code: Select all

/*test*/
update table set id = 1;
update table set idcode = 1;
/*test 2*/

marsupilami
Platinum Boarder
Platinum Boarder
Posts: 1956
Joined: 17.01.2011, 14:17

Re: Zsqlprocessor1 error comment in end scrit

Post by marsupilami »

Hello,

the problem is that the comment at the end of the script generates an empty statement. Not all databases support this. The follwoing will work:

Code: Select all

/*test*/
update table set id = 1;
update table set idcode = 1
/*test 2, note the missing semicolon in the line before.*/
Best regards,

Jan
Dfox
Fresh Boarder
Fresh Boarder
Posts: 12
Joined: 24.03.2024, 23:41

Re: Zsqlprocessor1 error comment in end scrit

Post by Dfox »

OK thanks :(
Post Reply