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
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