Re: trigger for indexfield

You missed out the FOR EACH ROW clause to make it as a row trigger.

 CREATE OR REPLACE TRIGGER "<table>"."<trigger_name>"  BEFORE INSERT OR UPDATE
 OF <Field> ON <Usr>.<table>
FOR EACH ROW

.....................

HTH John Chiu Received on Tue Nov 09 1999 - 05:15:53 CST