sql syntax error: incorrect syntax near ":=":

[Former Member]

I am getting error sql syntax error: incorrect syntax near ":=": line 12 col 16 (at pos 356)

while executing the trigger

create Trigger STATUS_UPDATE
AFTER INSERT OR UPDATE ON "tablename"
REFERENCING NEW ROW myNewRow
FOR EACH ROW
BEGIN
DECLARE flag boolean;
flag := true;
 IF :myNewRow."org" IS NULL or :myNewRow."env" IS NULL or :myNewRow."clusterId" IS NULL THEN
	flag := false;
 END IF;
 IF :flag = true THEN
	myNewRow."status" := 'success';
 END IF;
END;

[KonradZaleski]

Try to remove colon befor flag variable:

IF flag = true THEN

[Former Member]

No it doesnot work same error konrad

Could not execute 'create Trigger STATUS_UPDATE AFTER INSERT OR UPDATE ON ...'
Error: (dberror) [257]: sql syntax error: incorrect syntax near ":=": line 12 col 16 (at pos 355)

you can check the document

https://help.sap.com/viewer/4fe29514fd584807ac9f2a04f6754767/2.0.03/en-US/20d5a65575191014946db96aae...

CREATE TRIGGER TEST_TRIGGER
 AFTER INSERT ON TARGET FOR EACH ROW
 BEGIN
     DECLARE SAMPLE_COUNT INT;
     SELECT COUNT(*) INTO SAMPLE_COUNT FROM SAMPLE;
     IF :SAMPLE_COUNT = 0
     THEN
       INSERT INTO SAMPLE VALUES(5);
     ELSEIF :SAMPLE_COUNT = 1
     THEN
       INSERT INTO SAMPLE VALUES(6);
     END IF;
 END;

[Former Member · Accepted solution]

solved !!!! [Assignent issue]

myNewRow."status" = 'success';

[former_member747771 · Accepted solution]

Good, fine!