FRM-40200 Field Protected Against Update After Date Format Changed
(Doc ID 1043231.6)
Last updated on JANUARY 30, 2024
Applies to:
Oracle Forms - Version 6.0.8 and laterOracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.
Goal
A WHEN-NEW-FORM-INSTANCE trigger does a
SET_ITEM_PROPERTY('DATE_ITEM',enabled,property_false);
This disables the date_item at the start of form.
Then in a PRE-QUERY trigger, one sets the date_item back to enabled with
SET_ITEM_PROPERTY('date_item',enabled,property_true);
However, when trying to update against the date_item, the following error occurs:
FRM-40200:FIELD IS PROTECTED AGAINST UPDATE.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |