PRAGMA dbname.schema_version

[jota]

Hi

I want to know my database version.

UniQuery.ExecSQL('PRAGMA dbname.schema_version');

How i can get return value

Thanks in advance

[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;

[jota]

Hello

Thank you, works fine.