>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