Thank you Albert Berry for your prompt reply. The information I had supplied previously was in error. I thought the loop was executing once because it displayed data from the first row. Actually this display resulted from a previous access.
I finally discovered last night that the execution of a RUN command that came between the SET POINTER command and the WHILE loop somehow trashed the pointer, setting the error variable. The sub-routine that RUNs there is only ten lines and consists only of SET V commands, one IF >> ELSE , plus CLEAR and RETURN. Nothing else. Eliminating the RUN command by inserting those few lines of code into the prog works! Why should the RUN trash the pointer? I've never seen this before. Larry Lewis ----- Original Message ----- From: "Albert Berry" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, December 17, 2001 10:48 PM Subject: RE: WHILE exits in one pass > We will need to see the code, Laurence (and thanks for spelling your first name correctly!) > > Make sure the variables are declared before going into the loop. I would also suggest switching to the DECLARE CURSOR syntax from SET POINTER. It is SQL compatible, and somewhat more flexible than SET POINTER. > > > > "Laurence Lewis" <[EMAIL PROTECTED]> wrote: > > >I've been chugging along happily using RBase for DOS since 1989 (Version 3.1 > >I believe), and only now encounter this: > > > >Why should the error variable change from 0 and the WHILE loop exit after > >the very first NEXT is executed? > > > >That is, after only one row is done of the many in the table that SET > >POINTER is meant to process? > > > >When the IDENTICAL code operating on the IDENTICAL table is executed from a > >different app file, it works fine! > > > >Larry Lewis > > > >================================================ > >TO SEE MESSAGE POSTING GUIDELINES: > >Send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: INTRO rbase-l > >================================================ > >TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > >In the message body, put just two words: UNSUBSCRIBE rbase-l > > > -- > > > > > __________________________________________________________________ > Your favorite stores, helpful shopping tools and great gift ideas. Experience the convenience of buying online with Shop@Netscape! http://shopnow.netscape.com/ > > Get your own FREE, personal Netscape Mail account today at http://webmail.netscape.com/ > > ================================================ > TO SEE MESSAGE POSTING GUIDELINES: > Send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: INTRO rbase-l > ================================================ > TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] > In the message body, put just two words: UNSUBSCRIBE rbase-l ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: INTRO rbase-l ================================================ TO UNSUBSCRIBE: send a plain text email to [EMAIL PROTECTED] In the message body, put just two words: UNSUBSCRIBE rbase-l
