what is the proper technique for adding rows to a view? say the view is a simple one that only has one updatable table.

the tables in my app all have PK's. in each table definition, the default value for each PK is generated by a routine that increments a PK counter.

i have tried adding to the base table and then adding the same row to the view by doing scatter on the table and then append blank and a gather on the view but when i issue tableupdate(), changes to the view columns after the initial add are not saved back to the table.

it seems that i need to add to the base table first, including any default vaules for other attributes and then requery the view so that i can see the new row.

is the right?

thanks,
pbd