RE: QUICK Embedded SQL Question

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

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.