I have in my table a checkbox items, which its value should not be saved but only should insert records into some tables ( this because of the many-to-many relationships) if the value is checked (in my case I made it equals to 'true'). and it should delete records if the value is 'false' (the unchecked value). I wrote a code to perform what I want, here's it:
IF :C.CHOICE = 'TRUE' THEN
INSERT INTO C_C(ID, C_ID, CUST_ID, EVE_ID, NUM)
DELETE FROM C_CUST WHERE C_ID = 'C.C_ID';
but in the run time, it hangs the application and foces me to end it using "Task Manager" . I don't know what's wrong with my code.
if anyone knows, plzzzzz tell me and advice me.
Sorry I forgot to tell you, I put that code under WHEN-CHECKBOX-CHANGED trigger. Also I want the values of the checkboxes not to be saved in the table 'C'.. Should I rollback after the previous code in the same trigger??