Re: SQLServer ->Oracle : IF UPDATE(Column)....

Hi,
Look at :new and :old of rowlevel triggers in Oracle. Do a before insert, and compare the same field:

BEGIN
  IF :OLD.CREATED_DATE != :NEW.CREATED_DATE then

     raise something_rotten_in_the_state_of_denmark;   END IF;
END;

• P. Larsen zfred wrote in message <3654B4AF.F70A251A_at_ozemail.com.au>... In sql server you can do in a Trigger If Not UPDATE(AuditUserId) Begin Select @Msg = "Failed to Audit userid" Goto Error End

    thus checking that the user of an UPDATE sql did indeed also set the AuditUserId

    column.

    Oracle appears to have quite a set of trigger options, including one     where A trigger is called for a specified column update BUT i don't think

    this will work for me,
    because when the row updates, ie another trigger - update of the table -

    i need to check that the AuditUserId was set     AND the old and new value of AuditUserId could be the SAME!!

    By the way: I am using Oracle Lite 3.5

    I am out of ideas for porting this one!     anyone got an idea ?
    i'll be so thankful. Received on Mon Nov 23 1998 - 06:58:32 CST