Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Intermittent error 1705 on CREATE TABLE
Message
De
11/03/2014 06:18:40
 
 
À
10/03/2014 13:31:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01595953
Message ID:
01596093
Vues:
42
>>>Definitely not file name collision because there's a strict naming convention for these files that includes a primary key value as part of the file name. And there's now code that ensures that if a file of the same name exists, we close it and delete it before creating.
>>
>>Just thinking... if there's a previously existing file, its deletion is actually passed to the OS, which may execute it in a separate thread. I've seen (long ago, on a slower machine) situations when the previous file would still exist at the time the new one was created - and when debugging it was impossible to re-create,simply because debugging give the other thread the time to complete its task.
>>
>>To check this, check in the logs if deletion is related to the error. I seem to remember that in such a case I wrote a loop where I'd try to fcreate() the file, and sleep a dozen milliseconds until it succeeded. Then I'd just fclose() the handle and go on.
>>
>>Note that "seem to remember" does not guarantee that my context is the same as yours.
>
>Interesting theory. Easy enough to implement, if none of the other possilbities pans out.

that is what I meant with sprinkling doevents between close/erase and create...
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform