Page 1 of 1

try this but not work

Posted: Tue Jul 04, 2006 12:08 pm
by 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

Posted: Wed Jul 05, 2006 2:11 am
by 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

Posted: Wed Jul 05, 2006 2:20 am
by admin
Dear mfa786 please don't duplicate the thread and as I already requested you to have some spelling check before posting. thanks

Posted: Sat Jul 08, 2006 1:32 am
by RiazAhmad
Try this one
SET_BLOCK_PROPERTY('voumaster', DEFAULT_WHERE, 'vtype='||''''||vtypev||'''' AND 'entdate='||''''||o_date(sysdate,'DD-MON-YYYY')||'''');