Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Updateable Views . How To ...
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00498989
Message ID:
00499147
Vues:
21
Hi
Yes u are right about buffering but i the data in the columns is not being put !
After an append blank the data remains blank even after i change it.

Any idea y ?

>>Hello People
>>
>>I have a question.
>>
>>I have a updateable view as follows.
>>
>>Select People.Name, as PartyName , People.Code as PartyCode from People
>>
>>I have made it updateable in the view designer.
>>
>>In the view,
>>I use append blank to add a record to it and set fields to some New values.
>>
>>But the problem is the base table People is not getting updated.
>>
>>WHat am i doing wrong ?
>
>In the View Designer, you checked the box to Send Updates, and you identifeid the key and updatable fields? After you append the record and add data, you then either have to move the record pointer to another record in order to fire off an implicit TableUpdate() [if your view is record buffered], or you have to issue the TableUpdate() function. See VFP help on that function.
>
>I also recommend using table buffering instead of record buffering. See CursorGetProp() and CursorSetProp() in VFP help.
Regards
Hiten K M

( The best and the worst are yet to come .. keep coding ! )

My Resume >>
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform