>Hi all-
>
>Recently took the advanced VFP course, and was told that we could update a table through a local view using free tables.
>(He said something about a Data dictionary---not sure about how to do this)
>
>First of all, we have to use free tables because there are several FOX 2.X programs that use the .dbf's that are going to be shared between VFP and Fox2.X...therefore no database container can be used.
>
>Well, I could create a blank .dbc to allow me to create a local view, and when selecting a table for the view, I can choose "other" and select a free table, and the view works...
>but when I choose "Send SQL updates",(oh and I made sure I had the fields marked updateable), nothing is being changed in the live table.
>
>Is this because to have an updateable view, the tables must be part of a .dbc? I hope not....it seems a heck of alot easier to use a local view. If anyone knows how to get around this, please advise.
>
>Thanks
>Angie

Hi Angie,

I can update the view for FP 2.5 free table just fine.
What type of buffering do you use? If table buffering, do you issue TABLEUPDATE() before you check the underlying table? Could be that underlying table is also buffered by any chance?