Calvin,

You say you're using table buffering and my guess is that you're also using optimistic table buffering. You might be running into the situation where there's a conflict between user's editing data at the same time ... last one in wins ... perhaps some stuff is just getting overwritten?

~~Bonnie


>I have had at least 2 customers where a transaction was saved inside of a
>Begin Trans
> select a table
> lsucces=tableupdate(.t.,.t.)
> if lsuccess
> select another table
> lsuccess=tableupdate(.t.,.t.)
> endif
>
> ...
>if lsuccess
> end transaction
>else
> rollback
>endif
>
>This process updates 10 tables. However, with these 2 customers there are transactions that do not include anything saved after the third table is processed. I would have thought this is impossible but I have their data and it certainly happened. If a table is in tablebuffer mode and is updated with tableupdate(.t.,.t.) and multiple records need to be committed, but some of them do not get saved what does tableupdate return? This is not clear and I have not figured out how to set up a test.
>
>Any help greatly appreciated.
>
>Thanks!