Re: How do refer to the whole record in triggers

In article <3224DF5B.6C68_at_best.com>, Anantha Kasetty <anantha_at_best.com> wrote:
>Hi,
>Everything is fine till here, but when I
>started writing the trigger, I realized that there were two fields in
>the master tables named "BEGIN" and the other one was "END".

whenever a column name is the same as a reserved word, enclosed the column name in double-quotes like this:

 insert into blah( this, that, "BEGIN", ... ) values ( ... )

case sensitive!

--
Dave Mausner, Consulting Manager, Braun Technology Group, Chicago.