| when updating field, getting frm-40212 [message #639715] |
Tue, 14 July 2015 11:02  |
rkhatiwala
Messages: 178
Registered: April 2007
|
Senior Member |
|
|
Hi,
I have only one block, containing 6 fields, out of which two fields - region & region_code - have LOV attached to it. User first selects region ( from a pop-up generated by LOV, when doubleclicking). Then for region_code, when double-clicked, it brings up pop-up ( LOV containing region_code where region_descr = :region). Works fine when inserting. If we want to change the region, it gives FRM-40212 INVALID VALUE FOR REGION. I am guessing its because the region_code value does not match the new region?? I change the region_code according to the new region, and when I try to save, again I get the same error. I tried with when-validate-item in both fields, but still getting error.
Thanks,
rk
|
|
|
|
|
|
| Re: when updating field, getting frm-40212 [message #639721 is a reply to message #639718] |
Tue, 14 July 2015 11:23  |
rkhatiwala
Messages: 178
Registered: April 2007
|
Senior Member |
|
|
Thanks Craig,
No format mask on REGION_CODE, and no CONSTRAINTS either. I am changing REGION first, and that point, it does not match with the existing REGION_CODE ( which was valid for the old REGION), and it gives this error. Attaching the error.
Also, with this error the cursor goes back to the REGION field, and the LOV used to select the region, pops up.
Thanks again.
[Updated on: Tue, 14 July 2015 13:09] Report message to a moderator |
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
