Help me..
I have table flow:
Test_tb( Test_ID numberic,Test_No char(5),Test_Name varchar(60) )
I created one trigger in order to increase auto column Test_id but code compile raise error.Can you help me solve this proplem.
This is my trigger:

CREATE TRIGGER "KEY_ID" BEFORE INSERT
ORDER 1 ON "DBA"."TEST_TB"
/* REFERENCING NEW AS new_name */
FOR EACH ROW /* WHEN( search_condition ) */
BEGIN
DECLARE @NEW_ID DOUBLE;
SELECT MAX(TEST_ID)+1
INTO @NEW_ID
FROM TEST_TB;
SET NEW.TEST_ID=@NEW_ID;--- this row raise ERROR
END

TK!