Is it possible to run a 'PRAGMA integrity_check' statement using a TLiteConnection component under Delphi 10.4 Sydney?
- If it is, how do we get the results of the integrity check?
-If it is NOT, is there another way to check an SQLite database integrity?
Thanks for your help.
LiteDAC - PRAGMA integrity_check
Re: LiteDAC - PRAGMA integrity_check
You can use PRAGMA integrity_check with our components. The following code example shows how to retrieve data with LiteQuery:
Code: Select all
...
LiteQuery.SQL.Text := 'PRAGMA integrity_check';
LiteQuery.DataTypeMap.AddFieldNameRule ('integrity_check', ftString, 1024);
LiteQuery.Open;
...
-
- Posts: 4
- Joined: Thu 22 Mar 2012 22:52
Re: LiteDAC - PRAGMA integrity_check
Thanks. That's exactly what I needed.