Hi Simon.
I do not have any TRIGGERs or FOREIGN KEYs.
I execute PRAGMA integrity_check and get no useful return... certainly
no errors.
I'm using a custom wrapper which uses this to execute stuff:
iResult = sqlite3_exec(m_pDatabase, sql, Callback, (void*)pResultSet,
&m_szErrorString);
Thanks,
Ian
On 08/09/2011 14:29, Simon Slavin wrote:
On 8 Sep 2011, at 2:22pm, Ian Hardingham wrote:
This query works fine:
SELECT * FROM eloResultTable
This query returns Error 11 - Database disk image is malformed
SELECT * FROM eloResultTable ORDER BY elo DESC
Please run "PRAGMA integrity_check;" on the database. You can code it into one
of your own apps or use the 'sqlite3' shell tool.
<http://www.sqlite.org/pragma.html#pragma_integrity_check>
Which API are you using to make changes to the database ?
Does your database have any TRIGGERs or FOREIGN KEYs in ?
Simon.
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
