Hi,
After creating the below trigger to increment the customer code automatically, I am getting the following Error Message.
The trigger script is as follows :
CREATE OR REPLACE TRIGGER tabCustomer_before_insert
BEFORE INSERT ON tabCustomer
FOR EACH ROW
BEGIN
DECLARE cust_code int;
IF NEW.customer_type = 'Company' THEN
SELECT max(customer_code) + 1
INTO cust_code
FROM tabCustomer
WHERE customer_type = ‘Company’;
ELSE
SET cust_code = NULL;
END IF;
SET NEW.customer_code = cust_code;
END;
Can anyone confirm if they have encountered similar issues before?
Best regards.