| MULTI4 Update Problem [message #2155] |
Wed, 24 June 2009 06:12  |
ajwid01
Messages: 26
Registered: June 2009
Location: UK
|
Junior Member |
|
|
Hi,
I have successfully implemented a MULTI2 pattern, where I can bulk update multiple child records of a parent.
However, when I am attempting a MULTI4 pattern for the same parent/child, I am encountering an issue with the update against the parent.
For some reason, after submit, the SQL is attempting to make a modification to the second element of the PK (which is not actually listed as modifiable).
The field is a VARCHAR2(4), and the return code suggests that it is being attempted to update this field to more than 4 characters.
("order_line_no cannot be greater than 4 characters.")
Actually, maybe this is not an output from a SQL error, but an inbuilt validation output, but I can't understand why it can report a validated field value but pressing submit would potentially alter the PK composite to something which would violate the mechanics.
T.
|
|
|
|
Radicore Forum
Search
Help
Members
Register
Login
Home
