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

Reply via email to