FRM-40200, Field Protected From Update, but it's not!

821529

In version 6 I'm getting an FRM-40200 error on a field that is, as far as I can tell, updatable. I added the following to the WHEN-MOUSE-DOUBLE-CLICK trigger & it returns True at the same time as the error occurs.

message(get_item_property('fieldname',UPDATE_ALLOWED));

So the user is allowed to update the field except that it's protected from update. I've checked the block properties & that's also updatable, any other suggestions please?

CraigB

I've checked the block properties & that's also updatable, any other suggestions please?

Sorry, I missed this in your first post. I'd have to agree with IQ then, search for code that set's the block or item to non-updatable.

Craig...

CraigB

An item will also inherit the property from the Block. Is your block Updatable?

Hope this helps,
Craig B-)

If someone's response is helpful or correct, please mark it accordingly.

IQ

Do a search for the Itemname in the form and see if there any other triggers or code that may be causing this.

821529

As I stated, the block is updatable.

There is a trigger that disables the field under some circumstances but not only do those circumstances not occur but also according to help that sets UPDATE_ALLOWED to False yet the message says UPDATE_ALLOWED is True.

That, to me, is the real mystery-what generates the FRM-40200 error when UPDATE_ALLOWED is True?

CraigB

I've checked the block properties & that's also updatable, any other suggestions please?

Sorry, I missed this in your first post. I'd have to agree with IQ then, search for code that set's the block or item to non-updatable.

Craig...

821529

Thanks. It did turn out to be code making the block non-updatable. I changed Get_Item_Property to Get_Block_Property & found that was False, then searching for the block name gave me the procedure that disabled that. Searching for that procedure gave me the procedure that called that, and searching for that procedure finally gave me the trigger that was calling it, proving that this was, in fact the problem. But as long as I was looking for the item I couldn't find it.