40200-Field is protected against update [message #150692] |
Fri, 09 December 2005 01:34 |
aditya_itc
Messages: 6 Registered: November 2005 Location: In
|
Junior Member |
|
|
Hi gurus,
I've got a data block created from a VIEW.
It displays 3 columns in a tabular format. The 1st 2 columns are display items and the 3rd one is a Combo Box.
On When-New-Block-Instance, I'm loading the block in Query mode using Execute_Query(No_Vaidate);
I'm also populating the combo list using a record-group programatically.
This finally displays all the records in the View into the screen with the 3rd column in form of a Combo.
But when I try to modify any combo item, I get a message "40200-Field is protected against update". I've checked the Insert Allowed, Update Allowed and Query Allowed properties of both, the Combo Item as well as the Data block, and all have been set to Yes.
Is it happening because the base table is a View ??
If yes, how do I deal with it ??
If No, what could be the problem ??
Need Help.
Thanks in advance,
Aditya
|
|
|
|
Re: 40200-Field is protected against update [message #151059 is a reply to message #150909] |
Mon, 12 December 2005 23:22 |
Scarlet.Zhu
Messages: 22 Registered: December 2005 Location: Shanghai
|
Junior Member |
|
|
djmartin wrote on Sun, 11 December 2005 23:25 | First off, put the execute query in the When-New-Form-Instance trigger, not the When-New-Block-Instance trigger.
David
|
Why its When-New-Form-Instance not When-New-Block-Instance?
|
|
|
|