Hi Dawa,

I've been experiencing more or less the same problems on views. Since the views are always local they're certainly not used by another user.

It seems to be a bug Ive hit (VFP 8 SP), but was not able to make a reproducable case. I've solved the problem by using table buffering in stead of no buffering or row buffering.

Please check if the problem still exists when using table buffering.

Walter,



>Hi, Everyboday,
>
>We have an application that allows multiple users (40+) from their workstations to access a VFP database that is located on a network server.
>
>Lately, the users have been complaining that they are losing data (records). As I checked the error log table that we created to track errors occoured. There are many error # 108 entries, which states that the "File is in use by another user".
>
>When I checked the code where the savings occurs, the basic process is as follows:
>

>set reprocess to automatic
>public gnError
>m.gnError = 0
>on error m.gnError = error()
>begin transaction
>insert into stafile (...) values (...)
>if m.gnError = 0 ;
>then
>   end transaction
>else
>   rollback
>endif
>

>The form that excecutes that code has BufferMode set to 0.
>The stafile has buffering set to 1 (no buffering).
>To solve the problems I have changed the above code to the following:
>

>set reprocess to automatic
>public gnError
>m.gnError = 0
>on error m.gnError = error()
>use aprdb!stafile in 0 order sta_id
>begin transaction
>if rlock("0",'stafile') ;
>then
>   insert into stafile (...) values (...)
>   unlock record 0 in stafile
>endif
>if m.gnError = 0 ;
>then
>   end transaction
>else
>   rollback
>endif
>

>
>The users are still losing data and they are really getting fed up with it.
>The record count in stafile is 1.2+ mil. and fields count is 51, total field length is 421.
>
>Any comments will be appreciated greatly!
>
>Dawa