>I don't work with views too much, but now that I've started playing with them a little, I think I will be incorporating them in many places where I was using tables,cursors etc. My question is, what is the proper way to update a view in, for example, a grid where the underlying tables are row buffered. If a user edits a field in the grid do I need to do a tableupdate() on the view and then on the underlying table, if so, does there need to be any error checking on the views tableupdate() since it is just writing to the buffer? I do have an error checking routine on the tableupdate() for my underlying tables which checks for various conditions, but am unsure of how the view works here. This is a local view from three tables and two of the tables have updatable fields. The view is coded in the init method of the form not within the view designer. Not to clear on this yet and could use some guidance.
>
>thanks:)
>
>John.


Tableupdating the view automatically updates the source tables without tableupdating them not unless you have some direct manipulations. Remember, views are built using SQL commands and these SQL commands only manipulates records which are committed and not buffered records which are uncommitted still.