Ok, In my Program, I need to be notified when a column is modified ( which one).
How can I do that? Thank you very much, Le 8 juil. 2014 17:10, "Roger Binns" <[email protected]> a écrit : > -----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 > _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
