Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Records disappear from view in a grid
Message
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Records disappear from view in a grid
Divers
Thread ID:
00680154
Message ID:
00680154
Vues:
52
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?
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform