>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.
Does the table have a proper key? There must be something that can be used as a primary key, and your view must know what it is. In this case, it really doesn't have to be a real primary key (there's no such thing in fox2x tables), but your view must be able to locate the record by that field. When you update, it creates an SQL Update command, which can be done in several ways, but each of them needs a key.