"Daniel Schnell" <daniel...@marel.com>
wrote in message news:494a68d0.8000...@marel.com
> is there a possibility to find out the difference before and after an
> update of a table through the update callback ?
>
> I know that I can register a callback to a table for getting the rowid
> of an SQLITE_UPDATE call. But the documentation doesn't state, if the
> callback can still retrieve the old values to find out what these were
> before the update occured.

I'm not sure I understand your question, but perhaps you are looking for 
an update trigger (see CREATE TRIGGER). Such a trigger can access both 
the old and the new values of each row touched by the statement.

Igor Tandetnik 



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to