Home » Developer & Programmer » Forms » FRM-40501 error using block on a join (Dev Suite 10g)
FRM-40501 error using block on a join [message #314819] Thu, 17 April 2008 21:18 Go to next message
**credo**
Messages: 4
Registered: April 2008
Junior Member
good day.

i have a base table block on a join (table A, table B).
i have set the following properties.
the join condition in where clause,
DML target for the block,
key mode of the block,
primary key column of the target table,
non-target columns' OueryOnly, InsertAllowed, UpdateAllowed to No(those DatabaseItem property is Yes)

however,i am encountering FRM-40501 error. could this be caused
by items/objects in the same block with DatabaseItem property set to No and InsertAllowed, UpdateAllowed to Yes. any suggestion on how this can be corrected. thanks.
Re: FRM-40501 error using block on a join [message #315551 is a reply to message #314819] Mon, 21 April 2008 21:09 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Have you solved your problem?

David
Re: FRM-40501 error using block on a join [message #315561 is a reply to message #314819] Mon, 21 April 2008 21:35 Go to previous message
**credo**
Messages: 4
Registered: April 2008
Junior Member
this problem has been solved.
error was not due to the non-base table items which are on the same block.

one primary key column in the target table, was not set as a primary key in the property pallette, just carelessness.

thanks.
Previous Topic: How to catch the KEY-F11 pressing
Next Topic: Sub Blocks Why?
Goto Forum:
  


Current Time: Thu Dec 08 19:57:43 CST 2016

Total time taken to generate the page: 0.09172 seconds