General information
Title:
Baffling 'file is in use' error
Can't seem to pinpoint cause of this error... hoping someone here can help.
I have an automated VFP9 app that converts xml email attachments into temporary tables and inserts records into FPD2.6 tables.
Of the 9000+ records it successfully created, intermittently I get an error emailed to me like this:
Error number : 108
Error message : File is in use by another user.
Line causing error : newid("volchgpro")
Line number of error: 63
Program with error : AWORK9
The actual line causing the error is: INSERT INTO DETAIL FROM MEMVAR. This is an INSERT into a FPD2.6 table. The 'newid("volchgpro")' above refers to a stored procedure that gets a unique id number for a table called volchgpro that is not involved with the INSERT at all. Why is this error occurring?
Extra info if this helps:
FPD2.6 app is used by several users for Order Entry.
VFP6 app is used to make adjustments/corrections to above FPD2.6 orders.
VFP9 app is used to automatically add records to above FPD2.6 orders.
Regards,
Ed Pecyna
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only