| FRM - 40200 ERROR [message #341127] |
Sat, 16 August 2008 20:35  |
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 816 times)
|
|
|
|
|
|
|
|
| Re: FRM - 40200 ERROR [message #341179 is a reply to message #341128] |
Sun, 17 August 2008 10:32  |
 |
Littlefoot
Messages: 21823
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?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
