Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
FILE IN USE on Windows XP Professional
Message
 
To
15/12/2003 17:17:36
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00859245
Message ID:
00859340
Views:
15
What does MESSAGEBOX(ALIAS()) say before the error occurs?

>That was one of our thoughts. However, not so. Everyone runs the same code and I can switch to another workstation (well not me actually as this site is about 3 hours away) and run the same program fine with all of the users in the same spot in the app as they were when it was run on this workstation.
>
>>
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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform