Transactions lock the table. The code should take this into account and lock the record for as short a time as possible.
I can't address the issue of missing records because you didn't provide enough information.
>I would like to ask opinion from the VFP users community, how good is VFP? I constantly have problems, while I just using standard code.
>
>All my code are like this:
>
>
>BEGIN TRANSACTION
>
>SELECT tableA
> REPLACE ...
>INSERT INTO tableB ...
>
>ltableUpdate=.n.
>SELECT tableA
>IF TABLEUPDATE(.t.)
> SELECT tableB
> IF TABLEUPDATE(.t.)
> ltableUpdate=.y.
> ENDIF
>ENDIF
>
>IF ltableUpdate
> END TRANSACTION
>ELSE
> ROLLBACK
>ENDIF
>
>
>The app only good in stand alone, if running in multi-user environment, I constantly got 'File is in use by another user', rollback, missing records.
>
>I'm using VFP9, dbf, XP. no power failure problem.
>
>I think I have lost confidence in VFP
>
>any comment please.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer