Re: Forms 4.5 How do you get the last record number without going to the Last Record ??

From: N Prabhakar <prabhs_at_po.pacific.net.sg>
Date: 1996/11/02
Message-ID: <55fgho$4l6_at_newton.pacific.net.sg>#1/1

Use COUNT_QUERY packaged procedure to find out the number of records the query is going to retrieve.

Please remember to use execute_query(all_records) to find out the total number of records which will be retrieved.

If you do not specify all_records, then forms will fetch the first record set and followed by another

Regards

N.Prabhakar DBA
Socgen Crosby Securities
Singapore Received on Sat Nov 02 1996 - 00:00:00 CET

This message: [ Message body ]
Next message: Roberto: "Re: SQL*LOADER: Skipping over fields in text file?"
Previous message: herman_at_iquest.net: "Re: Question: Export and Import"
Maybe in reply to: Steve Cosner: "Re: Forms 4.5 How do you get the last record number without going to the Last Record ??"
Next in thread: Roberto: "Re: SQL*LOADER: Skipping over fields in text file?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message