Tbular data block problem
I am using Oracle9i Forms9i to design my user screen. I have designed one data block having tabular layout i.e. my data block is having multiple rows (8 rows) and each row is having multiple columns (11 columns).
On the screen, the data has been entered by user and i am interested in inserting all these records (all 8 rows of 11 columns each) into oracle table. How can i do that.?? When i am referring :data_block.field_name then i am always getting the value of last row only. How can i refer the column of each row like in array.
Any suggestion / tips would be a great help to me.
Thanks a lot in advace for any suggestion / support to this issue.
If your block is based on a base table then you dont have to write any code to insert the records into the table. You can use the F-10 key to commit all the records into the base table.
Or if your block is not based on a table you can itterate all rows and insert the rows that way.
Click Here to Expand Forum to Full Width