Hi, Jeremiah-
Yes it should work. Have you specified a key field in the base table? DBSETPROP works on views.
As a suggestion for learning about manipulating views...You can download a nifty utility from
www.stevearnott.com called GENDBCX.PRG. First, create a simple view in the view designer on a table with a primary key. Make sure you set the key field and the updateable fields and check the Send SQL Updates box on the Update Criteria tab.
Then, run gendbcx on your DBC and check out the code it generates. It'll give you a good idea of how to manipulate views programmatically.
Also, I've found Jim Booth and Steve Sawyer's book
Effective Techniques for Application Development with Visual FoxPro 6.0 really helpful for understanding view and buffering issues.
>Hi,
>
>Is there an easy way to update base tables for local views? Maybe I'm doing something wrong, but I've tried the TABLEUPDATE command, in conjunction with table buffering, etc., etc., and still can't get my base tables to update the way I'd like. It seems like the DBSETPROP command only works on remote views.
>
>I'd like to be able to enter data into a view, enter a simple command, and have my base tables reflect the changes.
>
>I've looked in the FAQ section, read several foxpro books about the matter, and waded through the help section of VFP, but haven't had much luck.
>
>Thanks for your help.
>-Jeremiah