Need help on inserting values into table in Forms
From: <celia_xi_at_my-dejanews.com>
Date: Sat, 24 Apr 1999 21:19:44 GMT
Message-ID: <7ftche$npg$1_at_nnrp1.dejanews.com>
[Quoted] Hi, all,
COMMIT; When I run the forms, I got an error:'FRM_40401 NO CHANGE TO SAVE'. I also try to use FORMS_DDL, 'FORMS_DDL('INSERT INTO tab1 VALUES (current_value')', another error occurs: 'FRM_40508 UNABLE TO INSERT RECORD'.
Date: Sat, 24 Apr 1999 21:19:44 GMT
Message-ID: <7ftche$npg$1_at_nnrp1.dejanews.com>
[Quoted] Hi, all,
[Quoted] In a trigger I wrote the following codes for retrieving values of elements of a list:
[Quoted] list_count:=GET_LIST_ELEMENT_COUNT(list_id); FOR i IN 1.. list_count LOOP
current_value:=GET_LIST_ELEMENT_VALUE(list_id, i);
INSERT INTO tab1 VALUES (current_value);
END LOOP;
COMMIT; When I run the forms, I got an error:'FRM_40401 NO CHANGE TO SAVE'. I also try to use FORMS_DDL, 'FORMS_DDL('INSERT INTO tab1 VALUES (current_value')', another error occurs: 'FRM_40508 UNABLE TO INSERT RECORD'.
[Quoted] Could anybody point me out why i can't insert values into table1? Any reply will be appreciated.
Mike
[Quoted] fding_at_idirect.com
-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Sat Apr 24 1999 - 23:19:44 CEST