>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.
VFP is good and reliable. The app is good in multiuser and I actually do not remember a single instance that I delivered for stand alone usage in the last 15+ years. However as with all the other languages it too depends on the coder writing robust code. With any language there are good and bad coding ways.
If the above codes were not pseduocode then I'd say that I could find few 'not reliable' coding already in there.
Cetin