DBAsupport.com Forums - Powered by vBulletin
Results 1 to 1 of 1

Thread: FRM-30050: Block with uniqueness check must have at least one key item.

  1. #1
    Join Date
    Jan 2009
    Posts
    1

    FRM-30050: Block with uniqueness check must have at least one key item.

    I create a block called "request_info". I create a view "request_master_info_v" for its base table. When click on the button to open request_info form and try to edit data and save it. First it pops up the ""ORA-01779: cannot modify a column which maps to a non key-preserved table"

    After I changed the Key Mode to Updateable, the above error message gone.

    But, come up unable to create a form with following two errors when I compile it

    FRM-30050: Block with uniqueness check must have at least one key item.
    Block: REQUEST_INFO
    Form: XXLICC
    FRM-30085: Unable to adjust form for output.
    Form not created

    I've set the primary key to true already. it's still the same problem.

    I am using Oracle 8i database and form version is 11.0.35

    How to fix?
    Last edited by rosetulip; 01-26-2009 at 05:15 PM.

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