Jim I don't know what your 2 while loops looks like. I'll assume 1 loop within another. If so, try changing the while command for each while loop to say:
While sqlcode <> 100 the That way maybe you can get the cursor to break where it stopped before. Make sense ? Bill Eyring -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Wednesday, June 20, 2012 5:25 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: labels not showing Most of the time (when I was paying attention) the value was 0. I am talking about the one where the cursor did not change as it was supposed to . I did not look at the one where the labels did print. James Belisle Making Information Systems People Friendly Since 1990 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dan Goldberg Sent: Wednesday, June 20, 2012 4:22 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: labels not showing When you were tracing it, did you watch the value of sqlcode? Maybe you can paste a snippet of the while loop? Dan From: jan johansen <mailto:[email protected]> Sent: Wednesday, June 20, 2012 1:55 PM To: RBASE-L Mailing List <mailto:[email protected]> Subject: [RBASE-L] - Re: labels not showing Had to ask. ;) Does the lable work if you TRACE all the code? I had a case where I could not find what was broken and the easy fix was to turn WHILEOPT OFF before I ran the code. -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 20 Jun 2012 15:51:14 -0500 Subject: [RBASE-L] - Re: labels not showing No! They are based on a chosen date from a popup calendar. I am in the midst of tracing the code and for some reason here is what is happening. The first cursor captures the order number. The second cursor captures the number of pieces (this will tell how many labels to print for this order) When the number of labels are done being processed (based on number of pieces) the first cursor is supposed to grab the next order. Right now it is not changing the order number in the first cursor. So what seems to be happening is the while loop never closes since it never goes on to the next order. It keeps cycling through the second cursor (number of packages) but always uses the same order number instead of going to the next one. The confusing thing is it works for a different day. James Belisle Making Information Systems People Friendly Since 1990 ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of jan johansen Sent: Wednesday, June 20, 2012 3:41 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: labels not showing The labels aren't based on .#DATE are they? -----Original Message----- From: "Jim Belisle" <[email protected]> To: [email protected] (RBASE-L Mailing List) Date: Wed, 20 Jun 2012 15:36:32 -0500 Subject: [RBASE-L] - labels not showing I have a strange problem with labels not showing for a specific date. If we run a command file bringing up today's Bill of Lading shipping labels the command works fine. The labels show to our screen and then we print them. If I run the same command file for tomorrow's date 06/21/2012, RBASE freezes up. I have tried this on three different computers, including one remotely and the same thing happens. If I try bringing up a specific BOL on this date 06/21/2012, it comes up on a form and we can print the labels. This command file is a cursor file run with a while loop WHERE SQL <> 100. Any suggestions as to where I should look? James Belisle Making Information Systems People Friendly Since 1990
