I am trying to convert code from Oracle to Sybase, where there are manipulations occurring on the :new.x values. These triggers are BEFORE INSERT, so whatever changes in the :new values are replicated in the insert into the table the trigger is placed on.
The Sybase triggers are fired after insert, but I can't seem to work out how to get the update values of the current table without invoking nesting issues.
Basically, if I do an insert into a table, I want, say, a value to be derived and updated on the row I'm inserting
I can do this in Oracle with :new.value = (derived) and it gets inserted into the table, no problem
However, in Sybase, whatever was entered as the base entry gets into the table, but I can't update the record just inserted without getting nesting trigger calls, or it just not working at all.
Help :<