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

Reply via email to