Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Data Environment gets totally hosed -- Desperate!
Message
De
21/11/1999 18:58:48
Christian Berrigan
Enterprise Data Solutions, Inc.
Brush Prairie, Washington, États-Unis
 
 
À
21/11/1999 14:10:58
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00293511
Message ID:
00293755
Vues:
29
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.
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform