Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Update a table via a grouped view
Message
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00364981
Message ID:
00365032
Vues:
19
Just curious. Would you really do it this way? While logically I know this should work, I just don't think I could put enough faith in a view like this to use tableupdate and hope all the records in the group by get updated. Just me personally, if I need fields from a group of records updated with the same values, I would go with the UPDATE SQL command.

>Make sure that all three fields are available in your view. Further, make sure that all three fields are checked as the key fields in the update tab of the view designer...
>
>HTH.....
>
>
>>I have a GROUPed view and when I update a field, I want the update to happen in all the related detail records. The uniqueness is a combination of 3 fields. I tried several combinations of keys, but I either get too many records updated or only one.
>>
>>Any help would be appreciated. Thanks
Mark McCasland
Midlothian, TX USA
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform