On Thu, Jan 13, 2011 at 2:32 PM, Simon Davies <simon.james.dav...@gmail.com>wrote:
> On 13 January 2011 10:56, Max Vlasov <max.vla...@gmail.com> wrote: > > On Thu, Jan 13, 2011 at 1:48 PM, Simon Davies > > <simon.james.dav...@gmail.com>wrote: > > > >> On 13 January 2011 10:28, Max Vlasov <max.vla...@gmail.com> wrote: > >> > >> CREATE TEMP TRIGGER [UpdatedRowIdTrigger] AFTER UPDATE OF RowId, Id ON > >> TestTable > >> BEGIN > >> UPDATE UpdatedRowId Set Value = new.rowid; > >> END; > >> > >> > > Simon, this particular change won't help globally since if you remember I > > don't know what exact column is aliased, but I probably will end up > without > > "OF" at all > > pragma table_info gives information allowing rowid alias to be determined > > There's at least one exception (see this post http://www.mail-archive.com/sqlite-users@sqlite.org/msg52462.html) Ok, thanks to Dan's suggestion and the following discussion everything now works like a charm, aliased fields can be changed and tracked. Thanks to all! Max _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users