Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Records disappear from view in a grid
Message
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Records disappear from view in a grid
Miscellaneous
Thread ID:
00680154
Message ID:
00680154
Views:
51
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
Map
View

Click here to load this message in the networking platform