>Thanks for your reply. I've done a little research and experimenting trying to understand the basics... When you have a buffered view as above and you don't add the base tables to the data environment, they are implicitly opened with no buffering. Its ok to send the updates to the base tables without buffering as long as there is no chance of network contention, (as in appending a new record). But if the possiblity for contention exists then the strategy should be to have the base tables buffered, either with cursorsetprop or by putting them in the DE, and do a tableupdate on both the view and then the base table all wrapped in a transaction.
>
>Does this sound right? Am I missing any gotchas?
>
>thanx again..Terry
Terry,
Looks like you have the right idea. Just to add: You won't need to buffer the base tables if you have forced overwrite set TRUE in your tableupdate() commands. It will only be a problem if you wish any changes by another computer to be reviewed before any update.
Barbara