Re: updated the record being inserted using trigger

On Oct 25, 4:56 pm, sai <go2...@xxxxxxxxx> wrote:
Hi All,

I am trying to update the record being inserted using a trigger, but
sybase doesn't seem to allow it, Can anyone suggest an alternative

here is what i am trying to do

create trigger tr1 on xyz for insert as
begin
update inserted set field3=field1, field4=field2
end
go

Thanks
Sai

You can certainly update the row you inserted in an insert trigger -
however, you have to insert the row in the base table. "inserted" is
a read-only pseudo table.

Instead, write the trigger like:

create trigger tr on xyz for insert as
update xyz set field 3 = field 1, field 4 = field2 from xyz, inserted
i where xyz.primarykey = i.primarykey

.

Relevant Pages

  • Re: How can i call a Trigger in ASP.NET ?
    ... decompose your trigger logic into 2 items, 1 being the trigger, the ... other being a stored procedure that the trigger can then call. ... if you have an update trigger on column ... XYZ, then if you issue an UPDATE table SET XYZ = XYZ (dummy SQL ...
    (microsoft.public.dotnet.framework.aspnet)
  • updated the record being inserted using trigger
    ... sybase doesn't seem to allow it, ... create trigger tr1 on xyz for insert as ...
    (comp.databases.sybase)
  • Re: updated the record being inserted using trigger
    ... sybase doesn't seem to allow it, ... You can certainly update the row you inserted in an insert trigger - ... Works like a charm, Thanks a bunch ...
    (comp.databases.sybase)