-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On 07/07/14 23:22, Micka wrote: > I know that there is a callback that can be called when a column is > updated.
Are you sure about that? > SQLITE_API void *sqlite3_update_hook( [...] > I tried to find when this function is called in the sqlite3.c . But I > didn't find it ... https://sqlite.org/c3ref/update_hook.html A relatively simple solution is to use a trigger to save old row values on update to a different table. However it would be more helpful if you said what the big picture problem you are trying to solve is, rather than dive into one potential solution. For example the authorizer API can be used to find out exactly which columns a statement modifies. Roger -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iEYEARECAAYFAlO8Cd8ACgkQmOOfHg372QTSfQCfZHzBbpJiI5ollGT8xhbX7YVH oHcAoM6KLJ+uYsS0r7lB3vxAPBkmc9pk =Zzor -----END PGP SIGNATURE----- _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
