On 13 Jan 2011, at 8:53am, Dan Kennedy wrote: > On 01/13/2011 02:31 AM, Max Vlasov wrote: >> Hi, >> for queries like UPDATE ... WHERE rowid=... one can in most cases reread the >> record (based on the rowid) and keep for example the cursor in the grid at >> the same record. But what if one of changed field is aliased to rowid, is >> there a way to find/track the changed record? In other words, how to find >> out the new rowid value for this record > > CREATE TEMP TRIGGER...
Genius. There appears to be no documentation on <http://www.sqlite.org/lang_createtrigger.html> about what the TEMP(ORARY) keyword does. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users