how form opening time get data as per given date

[mfa786]

my promlem is how use between funciton in form opening where clasee for date

i use this code but not give me result

such as

:global.newparty :=0;
declare
vtypev varchar2(15);
BEGIN
vtypev :='BPV';
set_block_property('voumaster', default_where, 'where vtype='||''''||vtypev||''' and entdate between '01-07-2005 and '30-06-2006');
go_block('voumaster');
execute_query;
set_block_property('voumaster', default_where, '');
END;

please send me idea how i get data only given date

thank

aamir

[mirza_rehan]

Use this code for yours problem..

<b>declare
vtypev varchar2(15);
v_Where Varchar2(200);
BEGIN
vtypev :='BPV';
v_Where := 'vtype='||''''||vtypev||''' and entdate between ''01-Jul-05'' and ''30-Jun-06''';

set_block_property('voumaster', default_where, v_Where);
go_block('voumaster');
execute_query;
set_block_property('voumaster', default_where, '');
END;</b>

i am not check this code but i am sure it will work well and solve yours problem.........

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