Re: Need help on inserting values into table in Forms

The COMMIT statement is interpreted as a COMMIT_FORM and as far as forms is concerned, it hasn't
inserted any rows and hence you receive the 'no changes to save' message. You can suppress the message
by altering the value of :system.message_level or you can issue the commit via the forms_ddl built-in, ie:
FORMS_DDL('COMMIT') which is not interpreted as a COMMIT_FORM and hence no message.

<celia_xi_at_my-dejanews.com> wrote in message news:7ftche$npg$1_at_nnrp1.dejanews.com...
> Hi, all,
>
> In a trigger I wrote the following codes for retrieving values of elements
of
> a list:
>
> 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'.
>
> Could anybody point me out why i can't insert values into table1?
> Any reply will be appreciated.
>
> Mike
> fding_at_idirect.com
>
> -----------== Posted via Deja News, The Discussion Network ==----------
> http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Sun Apr 25 1999 - 22:37:09 CEST