Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Views vs. table itself?
Message
De
16/09/1999 16:04:49
 
 
À
16/09/1999 15:20:05
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00265613
Message ID:
00265645
Vues:
17
>Is it always best to work with views instead of the tables themselves?
>(I'm very new to VFP) and am having a little trouble. If I change the value in one column of a grid, it correctly updates the table it came from, but if I delete the record it doesn't and if I try to insert a record it brings up an 'Add Record' dialog and forces an 'add record to child only'. Not sure what's going on. I think I have the Integrity of the tables in the DBC set correctly.


Do you have SET DELETED ON, as for adding records whats your "add" code look like? I usually do something like:
m.KeyField = PARENTTABLE.KeyField
INSERT INTO CHILDTABLE (CHILDTABLE.KeyField) VALUES (m.KeyField)
HTH
Thanks
Jon
Non-MVP Non-MCP Non-MCSE

Visual FoxPro, What else is there?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform