Re: SQL*Form 3.0 question (finding #num of rows queried?)

In article <2qoccj$avp_at_gaia.cc.gatech.edu>, warner_at_cc.gatech.edu (Byron Warner ) wrote:

>
> I would like to find out how many records where returned
> from a query is there a better way than this?
>
> procedure count_records(num out number) is
> tmp number;
> begin
> tmp := :system.trigger_record;
> last_record;
> num := to_number(:system.cursor_record);
> go_record(tmp);
> end;

You can redefine the keys for ENTER_QUERY and EXECUTE_QUERY with execute_query (enter_query resp.) ;
count_query ;

May be the procedure count_query is populating a GLOBAL variable (check with your Oracle support). By definition it displays the message:
FRM-40355: Query will retrieve <number> records.  

> --
> Byron F. Warner | Phone: (404)953-4531
> College of Computing | Internet: warner_at_cc.gatech.edu
> Georgia Institute of Technology | Atlanta Georgia, 30332
> "The opinions expressed here should be yours too!"

Hope this helps
LM

-- 
Leo Mannhart
Planning Office
University of Zurich               phone: ++41 1 257 23 34
Kuenstlergasse 15                    fax: ++41 1 257 22 12
CH-8001 Zurich, Switzerland        eMail: mannhart_at_zuv.unizh.ch