[RBASE-L] - Re: Converting from pointer to fetch

[Fitts, David A.]

Karen, 
 
Thanks ever so much for this information. I did not realize the
limitation existed and will watch out for it. 
 
Even better I like not having to do the double fetch lines. 
 
Thanks again,
Dave Fitts
State of Maine

________________________________

From: rbase-l@rbase.com [mailto:rbas...@rbase.com] On Behalf Of
karentel...@cs.com
Sent: Friday, June 19, 2009 1:22 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: Converting from pointer to fetch


Dave:   As we found out from the recent batch of comments on this
subject,
the WHILE SQLCODE <> 100 works *ONLY* if the "fetch" statement is
the last command before the ENDWHILE.

Some people, including myself, don't program that way because it
requires
you to have 2 fetches in the code.

Karen




        Hi,
        
        I too am converting an old database with lots of SET POINTER
commands. 
        What I have found works is to use: 
        
        WHILE SQLCODE <>100 THEN 
        
        In place of any old line that looks like
        
        WHILE var = 0 THEN
        
        This seems to run the cursor/pointer through the data and stop
at the
        end without any problems.
        
        Regards,
        Dave Fitts
        State of Maine