SQLite SQL Errors

In this forum we will discuss things relating the ZEOSLib 6.6.x stable versions

Moderators: gto, EgonHugeist

Post Reply
Plavozont
Fresh Boarder
Fresh Boarder
Posts: 8
Joined: 06.01.2012, 11:22

SQLite SQL Errors

Post 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...
Plavozont
Fresh Boarder
Fresh Boarder
Posts: 8
Joined: 06.01.2012, 11:22

Post 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...
Post Reply