try this but not work

[mfa786]

sir i try this but not work

SET_BLOCK_PROPERTY('voumaster', DEFAULT_WHERE, 'where vtype='||''''||vtypev||'''' AND 'entdate='||''''||o_date(sysdate,'DD-MON-YYYY')||'''');

please give me idea

[mirza_rehan]

Use same logic as this link

topic.asp?TOPIC_ID=181

take care
Allah Hafiz

Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807

When ever you pray
Please remember me and my family

[admin]

Dear mfa786 please don't duplicate the thread and as I already requested you to have some spelling check before posting. thanks

[RiazAhmad]

Try this one
SET_BLOCK_PROPERTY('voumaster', DEFAULT_WHERE, 'vtype='||''''||vtypev||'''' AND 'entdate='||''''||o_date(sysdate,'DD-MON-YYYY')||'''');