This content has been marked as final. Show 8 replies
Rajnish Chauhan wrote:Hi
i have push button on my form.
And on push button i have written insert statement .
after fill up the form when click on button its not getting any error.
but the records dont get insert into table.
-------------------------on push button--------
insert into LOGINDETAILS (EMPID, EMPFIRSTNAME ,EMPMIDDLENAME ,EMPLASTNAME , USERNAME , PASSWORD)
values ( seqlogindetails.nextval,
when dup_val_on_index then
message(-20001,'duplicate data found');
when others then
Edited by: Rajnish Chauhan on Jan 29, 2013 3:11 AM
After your insert statement write
Hope it works..
Rajnish Chauhan wrote:Commit is interpreted as COMMIT_FORM, then starts the Forms standard commit process, with validations, firing triggers,etc.
why we use forms_ddl. why not commit.?
Forms_DDL() just sends a command to the database, so nothing is done inside the Forms module.
If you want to commit the whole form, use COMMIT. If you want to commit some extra code in the database, but without committing the form, use forms_ddl('commit')
Hope it's clear..
Rajnish Chauhan wrote:Make database block base on table you want to insert and at button write simply
ys its clear .
but on form there are 3 text box and one button.
whatever i have put into text and click on button it should insert into table right.
so it should work as simple commit_form as well.
data will auto save in table
Hope it helps