SQLite Forum

Possible bug: pragma table_info(A) does not work, but equivalent select does in preupdate hook
Login
What type of SQL command are you using to call the hook ?  <code>INSERT</code>, <code>UPDATE</code>, or <code>DELETE</code> ?

After the preupdate hook calls your routine, does your routine correctly had control back to SQLite to allow it to continue ?  Do you check the result code returned and make sure that the calling function returns <code>SQLITE_OK</code> ?

If one SQL command updates many rows of a table, are you expecting your hook to be called once or many times ?