Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot update data in multi-table view
Message
De
07/06/2006 18:49:38
 
 
À
07/06/2006 12:01:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP
Network:
Windows XP
Database:
Visual FoxPro
Divers
Thread ID:
01127605
Message ID:
01127718
Vues:
13
Multiple views is definatley the way to go.

I've done table updateable views, but only for updating a single table and having the child or parent info in the view for display purposes. I would never change a primary key in a view, indeed I'd never change a primary key at all once it has been created.

Sounds more like you need a paramerterized view that is requeried based on the parent tables primary key.
Sigfried Trent, aka FoxMan
(Working from his secret code cave, FoxMan battles the forces of darkness lead by the deranged and mysterious Bug Boy)
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform