Hello experts, I am new in oracle forms. I am using oracle forms 11g,weblogic server 10.3.5,oracle database 11g at windows 7 platform. I have a simple data block from base table.there is a tabular form is selected, It has four rows(records). Now I have to make 4 check boxes adjacent to records in data block in another data block.Now I have to make functionality in which only those records should be inserted into database table for which corresponding (in front of the record) check box is checked. Thank you regards aaditya.
You may go through every record in that block and add some business logic such as :
if not checked then
change record status as non insert status ( :system.record_status )
But as implementation experience , we don't suggest using that way
You may create a temp block (non base) , and just insert those records if checked
Commit_Form built-in function commits all the available data base fields. So you have to use separate insert into statement to complete your task.
for i in 1 .. 4
if :chk_box='Y' then
Insert into <table_name> values(field1,field2,....);