Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Report hangs the computer
Message
From
08/02/1999 16:45:38
 
 
To
08/02/1999 14:28:17
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00183927
Message ID:
00185284
Views:
27
>John:
>
>Here's the scoop, in case it makes any sense. After a long, drawn out debugging session I was able to ascertain where the problem comes from:
>
>The report I run has a temporary result cursor, which is related to five DBF -files. Most of the time the report works fine, pulling in information from the cursor and the related files. In this instance, however, it seems that the record pointer on one of those files got somehow "stuck", would not move and crashed the program. I was able to alt+ctrl+del back to windows, but eventually ran out of memory, anyway.
>
>So what's one to do? Well, I stumbled upon the solution to this problem accidentally by messing around with the related files -- browsing, etc. right before executing the report, and then running the report right after that. And the darn thing worked! So I wrote a few lines into my program to force the file pointers of the related files to the top and then forcing the pointer to the top on the parent file as well, and that did it. No more crashing. A happy(ier) client. Put away the asthma spray (for now). Cancel that Valium order. Go on with life. Until further notice.
>
>So there it is. Yet another unexplained mystery. Solved. Yet another piece of in itself useless information in the big burlap back of tricks. And I probably can't take that bag with me to Visual Fox or the next Windows platform.
>
>Oh well. Thanks for the ideas, anyway.
>
>'Til further notice.....

Glad you got it working. It's a strange one. Normally doing a simple "go recno()" will reset all the relations properly. Strange. Thanks for the info though.
Previous
Reply
Map
View

Click here to load this message in the networking platform