mardi 26 avril 2016

Accessing SQLite PRAGMA User_version in Delphi

How do I access the result of

PRAGMA User_version

in Delphi using DbExpress components?

My code thus far:

SQL_dataset1.CommandType:=ctQuery;
SQL_dataset1.CommandText:='PRAGMA User_version';
SQL_dataset1.Open;

If SQL_dataset1.IsEmpty=False then
begin
  SQL_dataset1.First;

  Result:=SQL_dataset1.FieldByName('User_version').AsInteger;
  ........

... gives an error telling me that no field called User_version exists.

Any help would be appreciated.

Aucun commentaire:

Enregistrer un commentaire