| FRM-40501 error using block on a join [message #314819] |
Thu, 17 April 2008 21:18  |
**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 #315561 is a reply to message #314819] |
Mon, 21 April 2008 21:35  |
**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.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
