General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Adding rows to a view
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only