Home » Developer & Programmer » Forms » frm-40200 I don't know why!!
frm-40200 I don't know why!! [message #116141] Mon, 18 April 2005 02:12 Go to next message
nedu
Messages: 3
Registered: April 2005
Location: Rawalpindi
Junior Member
Hello there,
I have a field in control block with database item = no.
the update allow and query allow properties are true. but once i press F9 to show lov it says field is protected against update. Please help me out.

Report message to a moderator

Re: frm-40200 I don't know why!! [message #116143 is a reply to message #116141] Mon, 18 April 2005 02:22 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
In what state is 'insert allow'? [It should be 'true'.]

Report message to a moderator

Re: frm-40200 I don't know why!! [message #116144 is a reply to message #116143] Mon, 18 April 2005 02:28 Go to previous messageGo to next message
nedu
Messages: 3
Registered: April 2005
Location: Rawalpindi
Junior Member
yes it is true. the insert allowed property is also true.
once i run the form and try to open an LOV it says field is protected against update. i don't have any trigger on form level i.e. all the field have default properties once the form runs.

Report message to a moderator

Re: frm-40200 I don't know why!! [message #116146 is a reply to message #116141] Mon, 18 April 2005 02:48 Go to previous messageGo to next message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Strange.

Okay ... something else is 'stuck'.

Make sure that your item is a 'text item', that it is 'enabled', that it is 'keyboard navigable', that 'query only' is 'no', that 'query allowed' is 'yes', that 'update only if NULL' is 'no'. Look at the LOV, check the 'column mapping properties' and make sure that the returned value is going to the field we just checked.

Report message to a moderator

Re: frm-40200 I don't know why!! [message #116156 is a reply to message #116146] Mon, 18 April 2005 04:41 Go to previous message
nedu
Messages: 3
Registered: April 2005
Location: Rawalpindi
Junior Member
The problem has been solved.
I've explicitly set the propery of the control block in new form instance trigger. i.e. its update and insert allowed properties.
Thanks for your help.
Regards.

Report message to a moderator

Previous Topic: Determining Shipping cost
Next Topic: Filling datablock
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 18:47:37 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.