Guys,
I want to change the background color of required textfield when user is in Data Entry Mode. And when the record is committed successfully the background color should be return to default one.
Thats what I have done so far.
Created one Visual Attribute which contains the back ground color.
In the create record of data block added the below code.
IF :SYSTEM.BLOCK_STATUS = 'NEW' THEN
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.BATCH',VISUAL_ATTRIBUTE , 'ENABLE_COLOR');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.VENDOR',VISUAL_ATTRIBUTE , 'ENABLE_COLOR');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.AMOUNT',VISUAL_ATTRIBUTE , 'ENABLE_COLOR');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.ACCOUNTING_DATE',VISUAL_ATTRIBUTE , 'ENABLE_COLOR');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.INVOICE_DATE',VISUAL_ATTRIBUTE , 'ENABLE_COLOR');
ELSE
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.BATCH',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.VENDOR',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.AMOUNT',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.ACCOUNTING_DATE',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.INVOICE_DATE',VISUAL_ATTRIBUTE , '');
END IF;
And in the key commit Follwoing code is added
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.BATCH',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.VENDOR',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.AMOUNT',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.ACCOUNTING_DATE',VISUAL_ATTRIBUTE , '');
SET_ITEM_PROPERTY ('MASTER_APM_INVOICE.INVOICE_DATE',VISUAL_ATTRIBUTE , '');
The problem is, Form is opening in the data entry mode, so the required fields have background color changed, and even in the query and execute-query mode the back ground colors are changed as required one.
Any help how to solve this?
Also, what tag should I use to highlight the code in my post, ,the forum FAQ says its {code:sql} but its not working and code is not formatted.
Regards