Dan While loops are optimized. When you run in trace the while loop is not optimized and that is why in trace it will work.
Buddy -----Original Message----- From: Dan Champion [mailto:[EMAIL PROTECTED] Sent: Thursday, July 10, 2003 1:01 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: RBw65.exe has caused an exception Ok... seeing as how I have done just this.... can you explain why it is wrong. (probably the answer to some of my little bugs I hadn't found) Dan At 07:23 AM 7/10/2003 -0600, you wrote: >Changing the value of the variable inside the while loop is ok, but try to >avoid defining and re defining vars in a while loop. By redefining, I mean >don't change the var type. > >This is the best way to do it: > >set var vfile text >while ...... >set var vfile = whatever >endwhile > > >DON'T do this: > >while ......... >set var vfile text = whatever >endwhile > > >AND DON'T do this: > >while ........... >set var vfile int = (25) >set var vfile text >set var vfile text = whatever >endwhile > >I would also use &vfile in your load command instead of .vfile. > >Troy > > >-----Original Message----- >From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of rich >Jasinski >Sent: Thursday, July 10, 2003 7:10 AM >To: RBASE-L Mailing List >Subject: [RBASE-L] - RE: RBw65.exe has caused an exception > > >I have finally found the line of code that is causing it to crash, even in >trace mode. I am doing a : >load tablea from .vfile as ascii >I redefine the vfile variable in a whileloop just before I do the load. >Could this be the problem? > >rich >----- Original Message ----- >From: "Ramsour Mike" <[EMAIL PROTECTED]> >To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> >Sent: Thursday, July 10, 2003 8:12 AM >Subject: [RBASE-L] - RE: RBw65.exe has caused an exception > > > > Rich: > > > > I had a rash of problems like this several months back. It was driving me > > crazy! I made a number of changes and enhancements that ultimately > > eliminated the problem. R:Base is running smooth as butter now. > > > > I would suggest that you carefully inspect each R:Base script/program that > > is involved in this process. In my instance I had a command file that had > > the notorious hanging continuation character. A line of code ended with a > > plus sign (+) that was not needed. > > > > Use R:Code to check your programs. Note that R:Code is not a compiler and > > it will not catch the hanging continuation problem but you may be >surprised > > to find some hard-to-find coding errors. > > > > I have also greatly reduced my use of temporary tables. A comment was >made > > some time back to the effect that temporary tables do not handle indexes > > well. I have cleaned up my code considerably. I create and type each > > variable very explicitly and then I clear them once they're not needed. > > Make sure you are not attempting to use a variable or redefining a >variable > > to an incompatible type depending on how it's being used. > > > > Review the rules for WHILE loops and using cursors if you use them. > > > > Beyond that make sure you have the latest service packs for all software. > > Service Pack 4 was just released for Windows 2000. > > > > Another thing that may have been causing me problems was a known conflict > > between Norton Antivirus and the Adobe Distiller software. Here again >make > > sure you are using the latest versions/patches/fixes. This goes both for > > the Norton product and the Adobe software. > > > > Others will probably chime in with other suggestions but I can tell you >from > > my own experience that I have eliminated nearly all R:Base crashes. > > Probably 99% of the time it's a programming problem or a software issue > > outside of R:Base. > > > > Hope that helps. > > > > Mike Ramsour > > voice: 740-829-4340 > > > > -----Original Message----- > > From: rich Jasinski [mailto:[EMAIL PROTECTED] > > Sent: Thursday, July 10, 2003 7:00 AM > > To: [EMAIL PROTECTED] > > Subject: [RBASE-L] - RBw65.exe has caused an exception > > > > > > > > > > > > > > I have a client that has the latest version of 6.5++. They are >experiencing > > a great increase in the number of time rbase crashes with the above error. > > When looking at the Dr Waqtson log it is always an access violation. The > > machine is a new 1.7gz with 2 gig of memory running win2000 professional. > > The problem seems to occur when a command file is selected off of a APP >pull > > down. The comand file starts executes a few lines of code then crashed. >When > > I trace the command file it runs without a problem. > > > > Any ideas? > > > > rich Dan Champion P.O. Box 223 Grandville, MI. 49428-0223 www.championsolutions.net
