Re: Problems with cursor in forms 4.5
From: Daniel Poweleit <powi_at_hgnet.de>
Date: 1997/02/07
Message-ID: <01bc14fb$b4312e00$8c8765c1_at_babsi.hgnet.de>#1/1
end;
Date: 1997/02/07
Message-ID: <01bc14fb$b4312e00$8c8765c1_at_babsi.hgnet.de>#1/1
Hello Srikanth!
You have to do something like this
declare
def_where varchar2(512);
begin
def_where:=' where st_id =' ||to_char(:station1.st_id) || ' and (sample_date between ' || to_char(:segments.firstdate,'DD.MM.YYYY') || ' and ' || to_char(:segments.lastate,'DD.MM.YYYY') || ')';
set_block_property('blc_analyzed_samples1',DEFAULT_WHERE,def_where); go_block('blc_analyzed_samples1'); execute_query;
end;
Good luck
Daniel Poweleit from Berlin Germany Received on Fri Feb 07 1997 - 00:00:00 CET