OraFAQ Forum: Forms » problem in enabling/disabling the block in post query

Home » Developer & Programmer » Forms » problem in enabling/disabling the block in post query

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

problem in enabling/disabling the block in post query [message #130417]

Sat, 30 July 2005 00:53

harmeet.gambhir
Messages: 30
Registered: June 2005

Member

hi everybody,

i want to disable the block for insert,update,delete for a certain condition and enable it for a certain condition. the code is as follows :

if po_details.po_status= 'F' then
--Set_Block_Property('po_details',INSERT_ALLOWED,PROPERTY_FALSE);
--Set_Block_Property('po_details',UPDATE_ALLOWED,PROPERTY_FALSE);
--Set_Block_Property('po_details',DELETE_ALLOWED,PROPERTY_FALSE);
else
null;
end if;

when i run the form the problem is that the po_details block is disabled for all times, but i want the block to be disabled only if the po_status is 'F' otherwise the block is to be enabled for insert, delete etc.

i am executing the code in post query trigger of the po_details block.

pl. help

thanks in advance..

harmeet

Report message to a moderator