Page 1 of 1
PRAGMA dbname.schema_version
Posted: Thu 20 Aug 2015 12:19
by jota
Hi
I want to know my database version.
UniQuery.ExecSQL('PRAGMA dbname.schema_version');
How i can get return value
Thanks in advance
Re: PRAGMA dbname.schema_version
Posted: Thu 20 Aug 2015 14:37
by MaximG
You can retrieve information about the database version using the following sample:
Code: Select all
var
UniQuery: TUniQuery;
begin
UniConnection.ProviderName := 'SQLite';
UniConnection.Connect;
UniQuery := TUniQuery.Create(Nil);
try
UniQuery.Connection := UniConnection;
UniQuery.SQL.Text := 'PRAGMA schema_version;';
UniQuery.Open;
ShowMessage(UniQuery.FieldByName('schema_version').AsString);
UniQuery.Close;
finally
UniQuery.Free;
end;
end;
Re: PRAGMA dbname.schema_version
Posted: Fri 21 Aug 2015 07:21
by jota
Hello
Thank you, works fine.