Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updateable Views . How To ...
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00498989
Message ID:
00499147
Views:
23
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 >>
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform