[SOLVED] ZEOS and SQLite3
lazarus / 63-Database

----------------------------------------------------------------------
dseligo · 2020-11-16 01:33

I am using ZEOS dbo and SQLite3.

Is there a way to get more specific error message when I have an error
in SQL query (TZQuery)? I always get only this: "SQL Error: SQL logic
error."

I use it on Windows, DLL is latest (3.33.0 version).

Thanks

----------------------------------------------------------------------
EgonHugeist · 2020-11-16 19:57

If you're using the 7.2 series:
use: TZConnection.Properties['ExtendedErrorMessage'] := 'true';
If you're using the 8 series of https://sourceforge.net/p/zeoslib/code
-0/HEAD/tree/branches/8.0-patches/: It's default.
Otherwise ... no there is no way.
Regards, Michael

----------------------------------------------------------------------
dseligo · 2020-11-18 22:02

I use 7.2.6 and it worked great, I just needed to modify it slightly
to compile it:
zcSQliteConnection.Properties.Values['ExtendedErrorMessage']:='true';

Thank you.