Tbular data block problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tbular data block problem

  1. #1
    Join Date
    Jul 2003
    Location
    Chennai, India
    Posts
    11

    Tbular data block problem

    Hi,
    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.

    Regards,

  2. #2
    Join Date
    Aug 2003
    Posts
    11
    Hi,
    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.

    Regards
    Slash
    (MCP)

  3. #3
    Join Date
    Jul 2003
    Location
    Sofia, Bulgaria
    Posts
    91
    Or if your block is not based on a table you can itterate all rows and insert the rows that way.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width