Hello dear Wappler community superstars !
I was wondering if (My)SQL transactions and locks could be used within Wappler ?
I can see that the syntax exists in the custom query autocomplete helper.
But so far, my attempts to execute transactions failed.
For instance, this test transaction :
produces the following error :
Now if I place each transactions in a seperate query, I get the following error on the first one “START TRANSACTION;” :
SQLSTATE[HY000]: General error: 2030 This command is not supported in the prepared statement protocol yet
Thank you very much for your help !