update checkbox if null

[KBALDWIN1]

When using the property palete there is no such thing as update if null on a checkbox. There is only update allowed. I need update allowed to be yes because the row is updated when the check box is checked. But after it has been checked I do not want it to be updated. Help!

I have the following When_Checkbox_Changed trigger on the item.

IF CHECKBOX_CHECKED('CORSPTK.COMPLETED') THEN
	:CORSPTK.COMPLETE_DATE := sysdate; 
ELSE
 :CORSPTK.COMPLETE_DATE := null;
END IF;
GO_ITEM('CORSPTK.COMMENT_TEXT');

 

[sem]

You may raise an error from when-checkbox-changed trigger