>
> I recently tried using transaction processing on a form
> with two child grids. The Rollback command made cancelling multiple actions
> easy to program. However, I found that transaction processing locks the
> file even for new record adds by another user. I contacted Microsoft and
> they confirmed this. They said that transaction processing had not been
> implemented with an eye toward individual record handling. I had thought
> that only existing records being modified, or a single append blank record,
> would be locked by transaction processing. I was wondering if anybody had
> tried using trnasaction processing and came up with a way around this.
>
> TIA
>
> Jim Boho
> Univ of Wisconsin

Jim,

>From what I've tried in VFP 5.0, W95 (the data reside on a local disk,
have not tried on the shared novell drive yet), transacation processing
does not lock the whole table: I locked a record on station (with
rlock()), and could update another record in the same table from within
a transaction on another station. The transaction fails if the same
record is updated, but that is to be expected.

HTH,

Marc