saravanakumar
Member
Hi Team,
Here is the requirement - I don't want to create a record for a customer table if cust-id field has value as "" (BLANK). There are 2 existing triggers (create & write) for the same table;
Create Trigger:
TRIGGER PROCEDURE FOR CREATE OF customer.
ASSIGN customer.create_dt = TODAY
customer.create_tm = TIME.
RETURN.
WRITE Trigger:
TRIGGER PROCEDURE FOR Write OF customer NEW BUFFER bCustomer.
IF INDEX(SESSIONARAMETER,"DEVELOP") > 0
AND BUFFER bcustomer:NEW /* is new record */
AND CAN-FIND(FIRST constVal NO-LOCK WHERE constVal.key = "ALTPATH"
AND constVal.val = bcustomer.BU-USERID) THEN
ASSIGN bcustomer.create_user_id = bcustomer.BU-USERID.
Note: I can't add this check surrounding the CREATE statement because the CREATE statement for CUSTOMER table is available in around 750 programs in our code base.
Is there a possibility of fixing this issue in WRITE trigger?
Can someone assist me in resolving the issue? Thanks in advance!
Here is the requirement - I don't want to create a record for a customer table if cust-id field has value as "" (BLANK). There are 2 existing triggers (create & write) for the same table;
Create Trigger:
TRIGGER PROCEDURE FOR CREATE OF customer.
ASSIGN customer.create_dt = TODAY
customer.create_tm = TIME.
RETURN.
WRITE Trigger:
TRIGGER PROCEDURE FOR Write OF customer NEW BUFFER bCustomer.
IF INDEX(SESSIONARAMETER,"DEVELOP") > 0
AND BUFFER bcustomer:NEW /* is new record */
AND CAN-FIND(FIRST constVal NO-LOCK WHERE constVal.key = "ALTPATH"
AND constVal.val = bcustomer.BU-USERID) THEN
ASSIGN bcustomer.create_user_id = bcustomer.BU-USERID.
Note: I can't add this check surrounding the CREATE statement because the CREATE statement for CUSTOMER table is available in around 750 programs in our code base.
Is there a possibility of fixing this issue in WRITE trigger?
Can someone assist me in resolving the issue? Thanks in advance!