| FRM-30050: Block with uniqueness check must have at least one key item. [message #382960] |
Mon, 26 January 2009 14:59  |
rosetulip
Messages: 6
Registered: January 2009
|
Junior Member |
|
|
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?
[Updated on: Mon, 26 January 2009 15:18] Report message to a moderator |
|
|
|
|
|
|
|
| Re: FRM-30050: Block with uniqueness check must have at least one key item. [message #383456 is a reply to message #383183] |
Wed, 28 January 2009 23:49  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
|
Senior Member
Account Moderator |
|
|
You can't update through a view which uses a 'distinct'.
Search this forum for 'all_updatable_columns' or 'user_updatable_columns' for explanations on how to update through a view.
You could also read a SQL manual for their ideas on updating through a view.
Once you have an updateable view your form will probably work.
David
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
