>I am using local views and optimistic table buffering as a rule. When updating the views with 'send sql updates' = .t. (vfp5.0a) the updates are normally sent to the base tables automatically. I keep seeing mention of double buffering side effects but no real info. What are the considerations of double buffering and what do you do to make your the updates reliable? Do I need to specifically do tableupdates on the base tables to be safe?

If you use buffered views, then base tables can be kept non-buffered.