General information
Title:
Updating data in a parameterized view - VFP 3.0 Win
I have built my first form that uses a parameterized view. The form has the view in a grid and the data can be edited.
The tables are not using buffering, the view is also set for no buffering (as far as I can tell). The parameter I pass in is the date and then only records that match the date are displayed in the grid.
The problem is that when I change values in the grid, the changes are written back to one of the original tables, but they are written to too many records.
The key that joins the two tables is a person's unique id, and the tables are in a 1 to many relationship with the many side of the relationship being updated by the grid.
The problem is that every record in the child table that matches the unique id gets updated and not just the one that are updated in the view.
Whew! Does this make sense?
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