Home » Developer & Programmer » Forms » Receiving error Frm-40212 on check box fields (forms 6i)
Receiving error Frm-40212 on check box fields [message #391641] Thu, 12 March 2009 15:07 Go to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

Hello all,

This error I am receiving is very confusing.
I have 9 check boxes on a tab, it has the following properties set:
value when checked = Y
value when unchecked = N
check box mapping of other values = not allowed
initial value = N

However when I am in run mode and try to click on the tab after this tab(that contains the 9 checkboxes ) I receive the following error:
FRM-40212 Invalid value for field chkbox1
......
FRM-40212 Invalid value for field chkbox8
FRM-40212 Invalid value for field chkbox9

But the crazy thing is, if I check all the boxes (set to 'Y') the errors go away and I am able to move to the next tab.

Does anyone have ANY ideas of what is going on? It looks like it always wants me to check all the boxes.

Re: Receiving error Frm-40212 on check box fields [message #391653 is a reply to message #391641] Thu, 12 March 2009 16:11 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Try to set their values explicitly to initial value, such as
:block.checkbox_1 := 'N';
:block.checkbox_2 := 'N';
...
:block.checkbox_9 := 'N';
Re: Receiving error Frm-40212 on check box fields [message #391836 is a reply to message #391653] Fri, 13 March 2009 16:28 Go to previous messageGo to next message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

Thanks this worked. I set all the checkboxes to "N" in the WHEN-NEW-FORM-INSTANCE trigger.

I am surprised this actually fixed the problem.
Re: Receiving error Frm-40212 on check box fields [message #391837 is a reply to message #391836] Fri, 13 March 2009 16:35 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Surprised? Why?
Re: Receiving error Frm-40212 on check box fields [message #391838 is a reply to message #391837] Fri, 13 March 2009 16:38 Go to previous message
deahayes3
Messages: 203
Registered: May 2006
Senior Member

I'm surprised it was that easy, lol. Plus I never had to set the defaults manually before for checkboxes.
Previous Topic: navigating through menus problem
Next Topic: how to fix the vlaue for current item?
Goto Forum:
  


Current Time: Sun Dec 04 22:51:13 CST 2016

Total time taken to generate the page: 0.14441 seconds