Delete a record in Write Trigger

[saravanakumar]

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!

 

[MaximMonin]

if bCustomer.cust-id = "" then RETURN ERROR.

 

[saravanakumar]

Thanks MaximMonin, fix is working fine.