Hi all,
Does SET_ITEM_INSTANCE_PROPERTY trigger works in the non database items??
I am using a check box (db item) that enable or disable a non db item according to the check box value.
It works fine while i enter new records, check db_item enable the ndb_item and also does the reverse, now when ever i query for these records and tried to update its value nothing change, and when i display the item property it was changed correctly but has no affect..
I am doing the following :
IF CHECKBOX='Y' THEN
SET_ITEM_INSTANE_PROPERTY('MY_ITEM',CURRENT_RECORD,INSERT_ALLOWED,PROPERTY_TRUE);-- FOR NEW RECORDS
SET_ITEM_INSTANE_PROPERTY('MY_ITEM',CURRENT_RECORD,UPDATE_ALLOWED,PROPERTY_TRUE);-- TO UPDATE
ELSE
SET_ITEM_INSTANE_PROPERTY('MY_ITEM',CURRENT_RECORD,INSERT_ALLOWED,PROPERTY_FALSE);
SET_ITEM_INSTANE_PROPERTY('MY_ITEM',CURRENT_RECORD,UPDATE_ALLOWED,PROPERTY_FALSE);
END IF;
When i searched i found the following:
>
setting this property to true to at the instance level only has no effect unless it is set consistently at the item, instance and block levels.
>
any advice?
Thanks
Edited by: HST on Jul 18, 2010 11:07 AM