how form opening time get data as per given date
Posted: Tue Jul 04, 2006 9:42 am
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
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