| which Trigger Should I use [message #87591] |
Wed, 19 January 2005 18:33  |
suddin
Messages: 6
Registered: January 2005
|
Junior Member |
|
|
Dear all Experts,
I have one item called status after executing query if the status='RC' then the status of the status item will be disabled.Which trigger and code should I use.
regards,
suddin.
|
|
|
|
| Re: which Trigger Should I use [message #87592 is a reply to message #87591] |
Wed, 19 January 2005 18:52  |
suddin
Messages: 6
Registered: January 2005
|
Junior Member |
|
|
One think Status is the list item and It has two value
RC and RQ and it is multiblock data.
I want to do only disable the item haveign RC value.
regards,
suddin.
|
|
|
|
| Re: which Trigger Should I use [message #87593 is a reply to message #87592] |
Wed, 19 January 2005 19:18 |
ashish
Messages: 107
Registered: December 2000
|
Senior Member |
|
|
if u are querying it then u can use when new record instance at form leval
eg.
if :Status = 'RC' then
set_item_property('Status',visible,property_false);
else
set_item_property('Status',visible,property_true);
end if;
hope this will work for u
ASHish
|
|
|
|
| Re: which Trigger Should I use [message #87594 is a reply to message #87593] |
Wed, 19 January 2005 19:31 |
suddin
Messages: 6
Registered: January 2005
|
Junior Member |
|
|
ASHish brother,
the when new record instance at form level trigger is working but it is disableing all the status record.
Problem is it is a multiblock record and the status has two value 'RC' and 'RQ'.I want to make only disabeling status having value of RC.
Thanks & Regards.
sudddin.
|
|
|
|
|
|
| Re: which Trigger Should I use [message #87606 is a reply to message #87594] |
Thu, 20 January 2005 19:20 |
ashish
Messages: 107
Registered: December 2000
|
Senior Member |
|
|
hi
i'm not understanding what u r trying to do but
1)if you want to disable hole record then u should use where condition in your statement or in block property(default_where).
2) and if u want to disable item not record then u should use what i mentioned in last post. only one thig u will have to
set_item_property('Status',enabled,property_true);
eg.
if :Status = 'RC' then
set_item_property('Status',visible,property_false);
else
set_item_property('Status',visible,property_true);
set_item_property('Status',enabled,property_true);
end if;
Hope this will work for you
ASHish...
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
