>>If you use remote view then IMO buffering (table buffering) itself is enough. If you run some processes on server, then you may use transaction within stored procedure you call there.
>Ed,
>
>You might still need a transaction if you are using nore than one remote view. The server side trnas will only wrap one view's update, but the VFP trans will wrap the whole group.
It could be the case. I'm really unsure how locks will be accomplished (and how safe it will be) on server. I would prefer (if possible) to get everything under one umbrella (either one view or one stored procedure).
Edward Pikman
Independent Consultant