Home » Developer & Programmer » Forms » when updating field, getting frm-40212 (Forms 6i, Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 )
when updating field, getting frm-40212 [message #639715] Tue, 14 July 2015 11:02 Go to next message
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

Report message to a moderator

Re: when updating field, getting frm-40212 [message #639718 is a reply to message #639715] Tue, 14 July 2015 11:16 Go to previous messageGo to next message
CraigB
Messages: 386
Registered: August 2014
Location: Utah, USA
Senior Member
Do you have a Format Mask on the REGION_CODE field? Can you post the full Error Message? Is there a constraint on the table that prevents the update of the REGION_CODE? When you update the REGION_CODE are you changing the REGION field first?

Craig...

Report message to a moderator

Re: when updating field, getting frm-40212 [message #639721 is a reply to message #639718] Tue, 14 July 2015 11:23 Go to previous messageGo to next message
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

Re: when updating field, getting frm-40212 [message #639732 is a reply to message #639715] Tue, 14 July 2015 15:00 Go to previous message
rkhatiwala
Messages: 178
Registered: April 2007
Senior Member
I recreated the record_group, and the corresponding LOV, and it is working fine.

Thanks

Report message to a moderator

Previous Topic: How to use analytical Functions Mode in Oracle Forms
Next Topic: FRM-40350: Query Caused no record to be Retrived.
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 12 21:36:47 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.