"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