Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Help! File is in Use By Another User.
Message
From
04/04/2001 04:48:16
Cetin Basoz
Engineerica Inc.
Izmir, Turkey
 
 
To
04/04/2001 03:18:56
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00491717
Message ID:
00491735
Views:
9
>For some reason users get this error:
>
>File is in use by another user (Error 108)
>You have attempted a USE, DELETE, or RENAME command on a file that is being used by another user on a network.
>
>On the replace line:
>
>
>select PDMLOG
>	APPEND BLANK
>	
>	replace lognum WITH nLognum, ;
>	        USER WITH gcInit, ;
>	        pdmname WITH prefsall.pdmname, ;
>	        TYPE WITH cType,;
>	        DATABASE WITH cDB,;
>	        DATE WITH DATE(),;
>	        TIME WITH TIME(),;
>	        mainkey WITH cMainkey,;
>	        olinekey WITH cOldLinekey,;
>	        nlinekey WITH cNewLineKey,;
>	        DATA WITH cData,;
>	        status1 WITH cStatus1,;
>	        status2 WITH cStatus2,;
>	        admstatus WITH cAdmStatus,;
>	        admstatus2 WITH cAdmStatu2,;
>	        admcode WITH cAdmCode
>
>
>Only happens in multi user environments and I'm not sure why.
>I search UT for this error and found zip!?!

Tim,
Honestly not sure of reason (unbuffered and someone else start to use record as soon as appended, fieldnames same as keywords-don't think so this is a reason...?)
I'd use 'insert into' instead of append blank+replace.
This works pretty well :
m.Field1 = ...
m.Field2 = ...
m.Field3 = ...
m.Field4 = ...
...
insert into myTbale from memvar
Cetin
Çetin Basöz

The way to Go
Flutter - For mobile, web and desktop.
World's most advanced open source relational database.
.Net for foxheads - Blog (main)
FoxSharp - Blog (mirror)
Welcome to FoxyClasses

LinqPad - C#,VB,F#,SQL,eSQL ... scratchpad
Previous
Reply
Map
View

Click here to load this message in the networking platform