| Primary Key in detail block [message #483983] |
Fri, 26 November 2010 03:43  |
theowais
Messages: 75
Registered: October 2009
Location: Multan
|
Member |
|
|
Dear Experts,
I've a master detail form.
I detail form there is no primary key. When it is executed the following error displayed :
FRM-30100: Block must have at least one primary key item.
Block: ASSETS_ISSUE_DTL
Form: FORM_ASSETS_ISSUE_DTL
What to do?
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
| Re: Primary Key in detail block [message #677173 is a reply to message #483995] |
Wed, 28 August 2019 16:46  |
bahubcd
Messages: 40
Registered: July 2007
Location: Bangalore
|
Member |
|
|
All of you are wrong, I read this below in one of the other forums. Dont just simply look at the error and suggest answers. We can very well have data blocks with no primary key and Oracle Forms is supposed to handle it via RoWID. This is a cryptic error which arises out of a different condition.
https://community.oracle.com/thread/281982
I ran into this same problem cloning a block in my form.
It turns out that you get this error, "FRM-30100: Block must have at least one primary key item." when the Query Data Source Name and the DML Data Target Name specify different tables.
Set DML Data Target Name blank, and the error goes away.
|
|
|
|
| Re: Primary Key in detail block [message #677176 is a reply to message #677173] |
Thu, 29 August 2019 00:31 |
 |
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
|
Senior Member
Account Moderator |
|
|
Are you sure the answer was wrong 9 years ago? Above all <hen the versions of the product are different.
Instead of (wrongly?) replying in a so old topic, you should answer and feedback in your own previous topics.
In this you are wrong for sure.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
