In my data block I want to restrict the number of record queried dynamically, That is in some instance it should display all record and in some scenario only 5 record.
I have a global variable i set that according to the scenario. And based on that I set the block property as follow, in the pre query(I think this is the place, advice me if I am wrong)
IF :GLOBAL.VAR_Q = 'N' THEN
set_block_property('MY_BLOCK', MAX_RECORDS_FETCHED, 5);
n := Get_Block_Property('MY_BLOCK',RECORDS_TO_FETCH);
else
set_block_property('MY_BLOCK', MAX_RECORDS_FETCHED,1000);
n := Get_Block_Property('MY_BLOCK',RECORDS_TO_FETCH);
END IF;
message('MAX_RECORDS_FETCHED :'||n);
But this changes does not take effect. and for this message i got always 0 in both scenario.
Thank in advance.