Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> SQLServer ->Oracle : IF UPDATE(Column)....
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 Thu Nov 19 1998 - 18:15:44 CST