General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Can anyone Demystify multitable view updating
I encourage anyone who beleives they can explain this concept clearer than the documentation to please respond. I created two simple tables and a inner join view to experiment with. The documentation example shows issuing replace statements referencing the fields qualified by table names not the view names. If I don't use any reference, I can update the entire view with a replace all. When I qualify the fields with the table the way the example shows, random records are updated, usually only the last one. What specifically is meant by "Views are updated on a table-by-table basis. You must ensure that for each table accessed in a view, the key field set is a unique key for both the view result set and the base table." I am referencing the help topic and example from "Updating Multiple Tables in a View" in VFP 7.
Thanks,
Gary Pike
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