Re: Developer 2000 Question Help Please!!
From: Luc Bosman <l.bosman_at_wanadoo.be>
Date: 2000/06/16
Message-ID: <rqljksggs7jsl1dsj6ufstl61rov56lg9u_at_4ax.com>#1/1
>> procedure my_record_count is
>> --
>> v_cursor_record number := :SYSTEM.CURSOR_RECORD;
>> v_record_count number := 0;
>> --
>> begin
>> go_record(1);
>> loop
>> if :SYSTEM.RECORD_STATUS != 'NEW' then
>> v_record_count := v_record_count + 1;
>> next_record;
>> end if;
>> exit when :SYSTEM.LAST_RECORD = 'TRUE';
>> end loop;
>> go_record(v_cursor_record);
>> end;
>>
>> Then, call this procedure from where you need to.
Date: 2000/06/16
Message-ID: <rqljksggs7jsl1dsj6ufstl61rov56lg9u_at_4ax.com>#1/1
that's a good idea... but your method will retrieve all records from the database... Thinks about table with 500000 records, and a block with lot of thinks to do in 'post query' trigger
On Thu, 15 Jun 2000 20:18:52 -0700, "Matt B." <mcb_at_fightspam.sd.znet.com> wrote:
>"Matt B." <mcb_at_fightspam.sd.znet.com> wrote in message
>> procedure my_record_count is
>> --
>> v_cursor_record number := :SYSTEM.CURSOR_RECORD;
>> v_record_count number := 0;
>> --
>> begin
>> go_record(1);
>> loop
>> if :SYSTEM.RECORD_STATUS != 'NEW' then
>> v_record_count := v_record_count + 1;
>> next_record;
>> end if;
>> exit when :SYSTEM.LAST_RECORD = 'TRUE';
>> end loop;
>> go_record(v_cursor_record);
>> end;
>>
>> Then, call this procedure from where you need to.
> >Whoops. I guess I didn't do anything w/v_record_count there after figuring it >out, did I? :-) Try this: > >procedure my_record_count(p_record_count out number) is >-- >v_cursor_record number := :SYSTEM.CURSOR_RECORD; >v_record_count number := 0;
-- Luc Bosman DEV/2000 Software Engineer Database and Network Administrator l.bosman_at_wanadoo.be ICQ 37011625 http://users.skynet.be/kobukai/ ---------------------------------------------------- | -°) (°- | | /\\ Linux the choice of the GNU generation //\ | | _\_v v_/_ | ----------------------------------------------------Received on Fri Jun 16 2000 - 00:00:00 CEST