Hi!

RTFM. Views are explained in several chapters in MSDN.

Just for this case, how view is updated automatically is dependent on the Buffering setting of view's cursor. Also, DBSetProp() affects only setting in database and does nothing with views already opened.


>Hi
>
>Can anyone tell me how to control when a view updates its base table?
>
>MyView is a local view. I've experimented with
>dbsetprop('MyView','view','sendupdates',.f.) and setting this property to .t. when I want the table to be udpated but with some unpredictable results.
>
>Experiments with cursorsetprop() also didn't workout.
>
>I've also noticed that the base table almost alway gets updated when i close the form that works with this view.
>
>I'm completely lost.
>Can't find any logic in it.
>
>This has kept me puzzled for much to long now :-(
>
>please help
>
>TIA.