Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Trying to use updateable views...
Message
De
08/11/1998 21:35:32
Nancy Folsom
Pixel Dust Industries
Washington, États-Unis
 
 
À
08/11/1998 17:13:20
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Divers
Thread ID:
00155397
Message ID:
00155618
Vues:
30
PMFJI, perhaps I am overreacting to the quoted statement, but you do not have to set a field in a view in order to set THAT SAME field to updateable. But yes, as Nick said, you do have to have _a_ key field for the table that you are updating fields in. The reason, as it's been explained to me, is how does the view know which record to update if it doesn't know what its key field is.

HTH

p.s. my sympathies to for working on views AND a deadline :-)

...
>>>But I can't make the other fields updateable UNLESS I make them keyfields as well... Am I missing something here?
>>
>>You have fields from 2 tables in your view, so if you want to be able to update them all, you should set 2 key fields (tstParent.prntid and tstChild.prntid), then you can make any of view fields updatable, with the condition that "All Tables" in "Tables" combobox on "Update Criteria" tab is selected.
>
>Ok, this is definitely something I've got to get a handle on, but in the meantime, I've got a project to finish and I'm going to have to stick to what I know for now.
>
>Thanks for your help
>
>Larry
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform