Page 1 of 1

Zsqlprocessor1 error comment in end scrit

Posted: 05.06.2024, 01:13
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*/


Re: Zsqlprocessor1 error comment in end scrit

Posted: 05.06.2024, 15:34
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

Re: Zsqlprocessor1 error comment in end scrit

Posted: 07.06.2024, 16:40
by Dfox
OK thanks :(