I AM QUITE ACCOMPAISHED AS SOME THINGS, I AM HOWEVER SUFFERING AT TRIGGERS, & THIS PARTICULAR ONE.
I HAVE TO UPDATE A FIELD IN THE SAME db AS THE FIELD CAUSING THE TRIGGER TO FIRE, but this field is not being inserted, it is being updated.
With my other triggers are at the point of the record being inserted and i can use the
CREATE TRIGGER TEST_UPDATE
SELECT MAX(tpid) AS r FROM table
IF UPDATE(NCATEGORYCODE3)
UPDATE NL_ACCOUNTS SET NCATEGORYCODE2 =(93)
WHERE tpid = R
methodology and it works ok
but what i can't seem to find out is how to referance a row that is being edited I was looking for a fetchcurrentrow(tpid) function so i could use the sale update ... where logic as above
any ideas
many thanks
rory
I HAVE TO UPDATE A FIELD IN THE SAME db AS THE FIELD CAUSING THE TRIGGER TO FIRE, but this field is not being inserted, it is being updated.
With my other triggers are at the point of the record being inserted and i can use the
CREATE TRIGGER TEST_UPDATE
SELECT MAX(tpid) AS r FROM table
IF UPDATE(NCATEGORYCODE3)
UPDATE NL_ACCOUNTS SET NCATEGORYCODE2 =(93)
WHERE tpid = R
methodology and it works ok
but what i can't seem to find out is how to referance a row that is being edited I was looking for a fetchcurrentrow(tpid) function so i could use the sale update ... where logic as above
any ideas
many thanks
rory