General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Records disappear from view in a grid
I've been trying to figure this out for quite a few days and learned nothing.
I have 2 tables: parent, child and a view: vchild. Both tables and the view
are table buffered. (mode 5) On a form I have a few parent fields and a
grid containing vchild. vchild is a subset of child records that have the
same key as the current parent. I have an Add and Update button on the parent form. When I click Add, a new form starts up that allows me to insert a new record into vchild. A unique key is generated (for view updating) along with the key that matches the parent. I can then add my data and tableupdate it so the changes are passed back to child. In the end I tableupdate child or tablerevert it to either save all the changes or none. I can insert a new
record into vchild, tableupdate(.f.,.t.,'vchild') and then see the new record
in the grid. I highlight it again and click Update on the form. I can see the
record in the vchild edit form. Then I change nothing and tableupdate again (that's what the Save button does). Everthing is still ok. However if I take that newly inserted record and modify a field on the vchild form, then tableupdate(.f.,.t.,'vchild') the new record disappears from the grid when I get back to the parent form. The status bar in VFP7 still shows the correct amount of records but you cannot see it. If I tableupdate(.t.,.t.,'child') on the parent form, the record is there when you go back to edit it again. It just disappears from the grid somehow. Hope I haven't been to wordy. Any ideas?
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