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... > I thought about a partial solution: to track that the rowid used in the > query is no longer exists so there was a change to some new value, but what > the value is unknown. > > There's also pragma table_info returning pk info, and I probably can track > the aliased fields but there's at least one exception in the docs... > > Any thoughts? > > Thanks, > > Max Vlasov > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users