Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Data Environment gets totally hosed -- Desperate!
Message
From
21/11/1999 18:58:48
 
 
To
21/11/1999 14:10:58
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00293511
Message ID:
00293755
Views:
30
I haven't solved the actual problem, but I do have a work around that was successful under Win98.

First I got rid of the SCAN..ENDSCAN in favor of FOR..ENDFOR, but that didn't help in and of itself. Still bombed on the same exact line. Haven't had time (mad conversion now) to analyze the code and explicitly release every object rather than letting them go out of scope.

So, in the first line after the SCAN I put:

FLUSH
WAIT WINDOW '' TIMEOUT .5

This worked, although it consumed way to much time to be a viable solution. Then I tried:

FLUSH
WAIT WINDOW '' TIMEOUT .1

Did not work. Bombed on same line of code. Then I tried:

FLUSH
WAIT WINDOW '' TIMEOUT .25

Did not work. Then I though perhaps it needs to be .5 but not for every iteration.

IF lnCounter % 50 = 0
FLUSH
WAIT WINDOW '' TIMEOUT .5
ENDIF

This did work, and with an acceptable minimum processing time hit. So I tried:

IF lnCounter % 100 = 0
FLUSH
WAIT WINDOW '' TIMEOUT .5
ENDIF

This also worked. The performance is acceptable "for now". I obviously need to get totally "type A" with my object variables. I don't know if this solution will work for a 25,000 member company yet, but as a work around it is encouraging.

Thanks for all your help and PLEASE let me know if you have any more ideas.



>>>I'll give these two a try. Thanks again. Any other/further suggestions are greatly appreciated.
>
>Christian,
>
>It may not be related at all, but when creating multiple selects in a loop, it might be wise to clean them up afterwards with a USE IN selectalias before moving to the next one, or if your selects are causing a table with disk presence, to close and delete the file before doing the next one.
>
>If you do get it solved, please report back so everyone will know what the problem was.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform