Home » Developer & Programmer » Forms » FRM - 40200 ERROR
FRM - 40200 ERROR [message #341127] Sat, 16 August 2008 20:35 Go to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
I have a control block wherein i have a text field
PO_NUMBER, I want to enter a value here, and populate data
...

its database item - No
query allowed - yes
insert allowed - No
update allowed - No

it is under one control block, whose properties

database datablock - no
query allowed - yes
insert allowed - no
update allowed - no

query data source type - table

when I run my form, it gives the following error

FRM-40200 :Field is protected against update

so i am not able to enter value in my po_number text box

i am attaching the image, anyone please do explain me why..


  • Attachment: mdoc.jpg
    (Size: 97.44KB, Downloaded 196 times)
Re: FRM - 40200 ERROR [message #341128 is a reply to message #341127] Sat, 16 August 2008 21:03 Go to previous messageGo to next message
ora1980
Messages: 251
Registered: May 2008
Senior Member
I have changed the item's query only property to yes

but still ia m getting the same error
Re: FRM - 40200 ERROR [message #341142 is a reply to message #341127] Sun, 17 August 2008 00:47 Go to previous messageGo to next message
aljabali
Messages: 53
Registered: July 2008
Member
change update allowed - yes
Re: FRM - 40200 ERROR [message #341179 is a reply to message #341128] Sun, 17 August 2008 10:32 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
ora1980 wrote on Sun, 17 August 2008 04:03
I have changed the item's query only property to yes but still ia m getting the same error

This item (po_number) belongs to a control block, which means that it isn't based on database table, view, ... "Query allowed" property is meaningless in this context as there's nothing to query. You need to INSERT value into this item, so - why did you set this property to "no"?

Also, it seems that it *might* be about master-detail relationship. Detail block is below the control block. But, you can't create this relationship if master block is a control block. So, would it be possible to make it a data block in order to avoid any coding to fetch detail records?
Previous Topic: Unable to open form
Next Topic: Developer 6i & Windows Vista
Goto Forum:
  


Current Time: Sat Dec 03 18:24:54 CST 2016

Total time taken to generate the page: 0.06836 seconds