Recent

« previous next »
Pages: [1]

Author Topic: [SOLVED] ZEOS and SQLite3  (Read 3351 times)

dseligo

  • Hero Member
  • *****
  • Posts: 1625
[SOLVED] ZEOS and SQLite3
« on: November 16, 2020, 02:33:02 am »
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
« Last Edit: November 21, 2020, 12:06:08 pm by dseligo »
Logged

EgonHugeist

  • Jr. Member
  • **
  • Posts: 78
Re: ZEOS and SQLite3
« Reply #1 on: November 16, 2020, 08:57:14 pm »
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
Logged

dseligo

  • Hero Member
  • *****
  • Posts: 1625
Re: ZEOS and SQLite3
« Reply #2 on: November 18, 2020, 11:02:44 pm »
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.
« Last Edit: November 18, 2020, 11:05:09 pm by dseligo »
Logged
Pages: [1]
« previous next »
 

TinyPortal © 2005-2018