Ok, I give up

[chidi]

/* If either call_id,request_id or resp_id is empty then
make sure that either completed_code is not 'Y', and Incompleted_Code is 'I' */


BEGIN
if token.r='Y' or :token.i is null)then
if token.call is null or :token.reqd is null or :token.resp is null
or :token_id.c1 is null or :token_id.c2 is null or :token.c3 is null) then
begin
message('RECORD CANNOT BE FINISHED WITHOUT A CAL_id, REQUEST_id AND RESP_id');
RAISE form_trigger_failure;
end;
end if;
end if;
END;

This code above is driving me nuts.
Before I even click on the forms to validate it, it throws out that exception.
Can anyone please help!

 

[lewisp]

What trigger is the code on?

 

[chidi]

It is on when-validate-item trigger (block level).
thanks,
I moved it to post-insert trigger.
I think it is ok now.
Does the code look ok to you?
thanks,

 

[lewisp]

Code is fine. Try using a pre-insert instead.