Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2004
    Posts
    30

    Unanswered: Checkbox values transfere

    hello every body.

    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:

    Code:
    IF :C.CHOICE = 'TRUE' THEN
    		INSERT INTO C_C(ID, C_ID, CUST_ID, EVE_ID, NUM) 
    		VALUES('612','C.C_ID','C203','EV3',3);
    	ELSE
    		DELETE FROM C_CUST WHERE C_ID = 'C.C_ID';
    	END IF;

    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.
    thankx

  2. #2
    Join Date
    Jul 2004
    Posts
    30
    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??

    I'll be apreciated for any advice.

  3. #3
    Join Date
    Jul 2004
    Posts
    30

    error message

    FRM-40735
    WHEN-CHECKBOX-CHANGED trigger raised unhandeled exception
    ORA-01401

  4. #4
    Join Date
    Jul 2004
    Posts
    30
    Thanks GOD that my problem is not so diffecult for me Only

    well, the problem was in one of my fields, 'ID'! it seems it's a reserved word in forms6i. So I change the code like the following:

    Code:
    IF :C.CHOICE = 'TRUE' THEN
       :c_c.id := '44';
    
       . . .
      and so on
    end if;
    and it worked!
    But . . .
    it didn't work in some forms :'(
    I don't know why. is it because of the version that I have is not the original version or what.

    if anyone knows why or how can I make it work for the other important forms, I'll be so appreciated.

    thx

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •