I am sorry for the typo, obviously the right sentence is:
Dim rs As RecordSet = db.SQLSelect("PRAGMA integrity_check")
and please note that PRAGMA integrity_check just checks for errors
but it doesn't try to fix them.
db.SQLExecute("VACUUM")
is your friend here ;-)
Regards,
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Nov 7, 2006, at 6:28 PM, Charles Yeomans wrote:
Thanks.
Charles Yeomans
On Nov 7, 2006, at 2:25 AM, Marco Bambini wrote:
No integrity check is performed during a Connect...
In order to trigger it you should write something like:
Dim rs As RecordSet = rs = db.SQLSelect("PRAGMA integrity_check")
Now rs contains a single string which is a description of all
problems. If everything is in order, "ok" is returned.
---
Marco Bambini
http://www.sqlabs.net
http://www.sqlabs.net/blog/
http://www.sqlabs.net/realsqlserver/
On Nov 7, 2006, at 12:58 AM, Charles Yeomans wrote:
I see that it's possible to do an integrity check on a
REALSQLDatabase database. Is this performed in the course of
calling Connect? Although I suppose that's a detail of
implementation, I'd rather not redo it if possible.
Charles Yeomans
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives of this list here:
<http://support.realsoftware.com/listarchives/lists.html>
