Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to update source table with record appended to view
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00098177
Message ID:
00098256
Views:
31
Sylvain is correct, but in addition you must have your view set to be updateable. Go to the View Designer and make sure ALL the fields in your table are marked to be upadated, that you have checked the "Send SQL Updates" box (easy to miss) and that your primary key is marked.

Finally, if your underlying table is buffered you will have to issue a second TableUpdate() to the base table.

HTH
Barbara


>Issue a TableUpdate() on the source table.
>
>HTH
>
>>My work with views continues. I am now trying to update the source tables with changes made in a local view. I am able to update existing records, but can't seem to have my view's newly appended records to also be appended to the source table.
Barbara Paltiel, Paltiel Inc.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform