× The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.


  1.  Home
  2. MIDRANGE-L
  3. February 2004

RE: QUICK Embedded SQL Question

Apparently SQLER3 also contains the estimated number of rows when a PREPARE of a SELECT is done.

Vern

At 02:50 PM 2/6/2004 -0500, you wrote:

Thanks, Rick. I knew it was in there some time. I just wasn't sure if it
was after a Cursor open or after a fetch.

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


|---------+-------------------------------->
|         |           <Rick.Chevalier@ameri|
|         |           credit.com>          |
|         |           Sent by:             |
|         |           midrange-l-bounces@mi|
|         |           drange.com           |
|         |                                |
|         |                                |
|         |           02/06/2004 02:34 PM  |
|         |           Please respond to    |
|         |           Midrange Systems     |
|         |           Technical Discussion |
|         |                                |
|---------+-------------------------------->

>------------------------------------------------------------------------------------------------------------------------------|
| |
| To: <midrange-l@xxxxxxxxxxxx> |
| cc: |
| Subject: RE: QUICK Embedded SQL Question |

>------------------------------------------------------------------------------------------------------------------------------|




The number of rows returned on a fetch are returned in SQLER3.  SQLER5 =
100  will indicate if you have reached the end of file.

I don't know of a way to get the number of records (or lack of records)
without performing at least one fetch.

Rick

> -----Original Message-----
> From: midrange-l-bounces@xxxxxxxxxxxx
> [mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
> MWalter@xxxxxxxxxxxxxxx
> Sent: Friday, February 06, 2004 12:39 PM
> To: Midrange Systems Technical Discussion
> Subject: RE: QUICK Embedded SQL Question
>
>
>
> SQLER3?
>
> Thanks,
>
> Mark
>
> Mark D. Walter
> Senior Programmer/Analyst
> CCX, Inc.
> mwalter@xxxxxxxxxx
> http://www.ccxinc.com



As an Amazon Associate we earn from qualifying purchases.

This thread ...
Replies:
Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].

Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.