On 28 Apr 2011, at 7:28pm, Frank Chang wrote: > Good afternoon, We are using the latest version of sqlite, 3.7.6.2 in > Windows XP 32bit ( and Centos Linux 5.5). sqlite3_step, sqlite3_reset and > sqlite3VdeExec says we have a corrupted database. We are not using the WAL > mode. > When I using sqlite3.exe to query the database, the queries return > correct values. So I am wondering if our database is really corrupted.
Use sqlite3.exe, or write your own code, to issue the following command: PRAGMA integrity_check; (from <http://www.sqlite.org/pragma.html#pragma_integrity_check>) Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
