Ok, I've looked up at : sqlite3_set_authorizer
So it looks like that I can be notified when the update query try to modify a column. Good. Thx you very much, I will try that later ^^ On Tue, Jul 8, 2014 at 9:04 PM, Micka <[email protected]> wrote: > 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
