U++ forum: Welcome to the forum

Re: SqlPerformScript bug: Not doing anything if script starts with "BEGIN;" and ends with "END;" [message #60211 is a reply to message #60208]

Fri, 13 October 2023 11:02

mirek
Messages: 13980
Registered: November 2005

Ultimate Member

Well, the problem is that SqlPerformScript is primary dedicated to DDL and must support creation of triggers:

https://www.sqlite.org/lang_createtrigger.html

Unfortunately, with most SQLs, you have to send trigger body as single statement (that probably includes Sqlite3 as well). Thus we need to detect BEGIN/END and supress sending after ';' until END is reached, then send the whole thing at once. That is the reason for the 'level' variable.

I am not sure how to solve your problem frankly. I would be happy with 'do not use SqlPerformScript for transactions' note in docs, but if you have any suggestions... But I do not want to overcomplicate SqlPerformScript by e.g. detecting whether the BEGIN is function body or start of transactions, that would be hardly manageable, which means chances are slim...

Mirek

Report message to a moderator