Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
FILE IN USE on Windows XP Professional
Message
 
À
15/12/2003 14:52:56
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00859245
Message ID:
00859315
Vues:
17
USE IN 0 (ddir+"archeadr") ALIAS arcorg
SELECT arcorg
Maybe not an issue - but I sometimes fear that a USE does not necessarily SELECT the alias. Perhaps "archeadr" is opened exclusively by another caller?

>Update: Forgot to mention that the tables all reside on a server and all are Windows XP Professional. None of the other workstations exhibit this error, in fact, when you receive the error if you move to another workstation the same code will run fine. It is in a prg that runs directly from the main menu in the default data session. No forms are even open at this point. The funny thing is that only restarting the SERVER (not the workstation) will free up the file for that workstation once the error occurs. It only happens on ONE workstation and ONLY on that line (after the file is opened and when the index order is set).
>
>On one machine only in Windows XP Professional we get a file in use error when an index order tag is set. I can verify that the table is open (only once) on the same machine and this error only happens on a single machine (so far). Everything appears identical to other machines when this error occurs (program trace, data environment, etc.)
>
>
>	WAIT WINDOW "Searching Receipts..." NOWAIT
>	SELECT 0
>*--ERROR DOES NOT OCCUR HERE - the file opens fine
>	USE (ddir+"archeadr") ALIAS arcorg
>	IF bad_error
>		=okay("Receipt file is in use.  Please check other workstations.")
>		IF !EMPTY(dbfarea)
>			SELECT(dbfarea)
>		ENDIF
>		RETURN
>	ENDIF
>*--ERROR OCCURS ON NEXT LINE and error is FILE IS IN USE
>	SET ORDER TO TAG profile
>	*---Open Transaction File
>	USE (ddir+"arctrans") ORDER TAG re_link IN SELECT(1) ALIAS arctrorg
>	SET RELATION TO re_link INTO arctrorg
>
Imagination is more important than knowledge
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform