Page 1 of 1

SQLite SQL Errors

Posted: 06.01.2012, 11:31
by Plavozont
I have delphi 7 + ZeozDBO 6.6.6-stable, i use it to connect to SQLite 3 embedded database, everything works, but on any sql syntax or any other error I get the message "SQL Error: SQL logic error or missing database", but I expect to see something like "SQL error: you have a syntax error near '...' ...". When trying to execute an SQL-request in "Database Browser" it shows the error details perfectly...

Posted: 06.01.2012, 21:13
by Plavozont
Actually on a second thought it's not always like that, sometimes it gives reasonable explanation of the error, but still not always. For example if i write a name of a function that do not exist, like string_length, it says "SQL Error: SQL logic error or missing database", without any details...