Page 1 of 1

sqlite version

Posted: Mon 19 Nov 2012 19:15
by sandy771
Can unidac return the version of the sqlite dll it is connected to?

or for that matter can it return the version of any driver it is connected to?

Re: sqlite version

Posted: Tue 20 Nov 2012 08:56
by Oma Hans
For SQLite, simply execute the following query while connected to a data base:

Code: Select all

SELECT sqlite_version();
For PostgreSQL it is

Code: Select all

SELECT version();
Don't know about other engines, but it should be similar.

Re: sqlite version

Posted: Tue 20 Nov 2012 09:35
by AlexP
Hello,

A version of the server in any provider (SQLite library) can be get using the TUniConnection.ServerVersion property. If a DB client is used for connection, you can find out the client version using the TUniConnection.ClientVersion property.