>Hello,
>
>We are using Visual Foxpro 5.0 and we are creating a framework. We are discussing if we should use Optimistic Table or Row locking. We are developing a multiuser enviroment.
>
>Could anybody give us the advantages and disadvantages of table and row locking? And which should we use?
>
>Thanks in advance for your answer!
>
>Greetings,
>Michiel Willems
>Using the account of Koos Veel
You should use table lock for small recordsets only, e.g. views. For all other cases use row lock.
Edward Pikman
Independent Consultant