OraFAQ Forum: Forms » control enable status of block at run time

Home » Developer & Programmer » Forms » control enable status of block at run time (forms 10g, win xp sp3)

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

control enable status of block at run time [message #599928]

Wed, 30 October 2013 04:52

m_shehpar
Messages: 73
Registered: October 2010
Location: Pakistan

Member

Hi all,

I have a scenario wherein i want to enable / disable a block based upon value of one of its column value. i.e., if value of approval status in (IN ( 'INCOMPLETE' , 'RETURNED' , 'REJECTED' ) THEN
SET_BLOCK_PROPERTY('RFN_HEADERS_ALL', UPDATE_ALLOWED, PROPERTY_TRUE);
SET_BLOCK_PROPERTY('RFN_LINES_ALL', UPDATE_ALLOWED, PROPERTY_TRUE);
SET_BLOCK_PROPERTY('RFN_HEADERS_ALL', DELETE_ALLOWED, PROPERTY_TRUE);
SET_BLOCK_PROPERTY('RFN_LINES_ALL', DELETE_ALLOWED, PROPERTY_TRUE);
else.....

but the code is not working in pre-query, pre-select or post-query. can anybody guide me @ this

regards

Report message to a moderator