Re: sql fetch, wasn't there something we could put in the sql select statement, or the sql fetch to "look ahead" to see if we are at the end

The only thing I can think of is if you also get a count and count the
record count as you go though. But that's not 100% either.

Kinda like dow (not %Eof)... you need to do a read to trigger eof.

On Wed, Mar 8, 2023 at 2:23 PM Gerald Magnuson <gmagqcy.midrange@xxxxxxxxx

wrote:

I am looping through a cursor, I do receive the sqlcod of -100 when I

have

processed all records.
wasn't there something I could do to tell me that I have fetched my LAST
record?
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.

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

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.