265 Not Behaving as Expected
Back to General discussions forum
Hello, I'm getting the following message when I submit my SQL for #265 - Update. Error executing query: Error on update near "from": syntax error However it works just fine when I run it using the built-in tool, as well as when I run the code on SQLLiteOnline. Did I make a mistake or is there an issue with the checker?
Hi Friend!
Thanks, that's a curious question. I myself haven't heard about this form before!
I guess you did everything correctly, but
The UPDATE-FROM idea is an extension to SQL ...
UPDATE-FROM is supported beginning in SQLite version 3.33.0 (2020-08-14)
So it's again the issue with old version of SQLite on server (which I wasn't able to easily fix). I'll try to set my hands on this in nearest couple of days so feel free either to just wait a bit (ping again if fix won't happen) - or rewrite the query to use some simpler mechanism.
Just an 'update', I managed to find a different solution in the meantime. Thank you
Hi. I hope it could help. If you use SQLite on the server and you try to:
insert into pets values (13, 'Lazy', 'cat');
you get the following error:
[System.Data.SQLite]
ErrorCode: 1
ErrorMessage: SQL logic error
table pets has 4 columns but 3 values were supplied
So maybe you could simply solve the problem just with:
insert into pets values (13, 'Lazy', 'cat', null);
Regards.