Home » Developer & Programmer » Forms » FRM-30050: Block with uniqueness check must have at least one key item. (Oracle form development 11.0.35)
FRM-30050: Block with uniqueness check must have at least one key item. [message #382960] Mon, 26 January 2009 14:59 Go to next message
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 #383015 is a reply to message #382960] Mon, 26 January 2009 23:58 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Do you have all the columns of the table defined in your block?

david
Re: FRM-30050: Block with uniqueness check must have at least one key item. [message #383183 is a reply to message #383015] Tue, 27 January 2009 09:58 Go to previous messageGo to next message
rosetulip
Messages: 6
Registered: January 2009
Junior Member
my block is linked to a view that has 4 tables in it. I only need to display several fields in my block. I don't need all the fields from 4 tables. attached is the view. Do you also need a copy of my update trigger?
  • Attachment: myview.txt
    (Size: 1.29KB, Downloaded 139 times)
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 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Using WebCam
Next Topic: How to change parameter name in all the forms..
Goto Forum:
  


Current Time: Sat Dec 10 11:07:29 CST 2016

Total time taken to generate the page: 0.06962 seconds