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           && all tables with buffermode=5
   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.