> > Are you using the latest version? > No, the version I am using is 1.7.9, which uses DiSQLite3 version 3.5.9 which is the same version of DiSqlite3 I compile in my projects I downloaded the latest SQLiteSpy 1.8.11 (which uses SQLite 3.6.21) and it worked as it should. So it looks like this is a bug in the older versions, though I am still not sure if the problem was SQLite or DiSqlite3 or which version exactly is was fixed. I guess I may have to take the plunge and update my version of DiSqlite3 to the latest - though it does have some changes (including new delete trigger behavior) that concern me with backwards compatibility Thanks Clyde