>>I am working on a database that a former employee designed. In this database, he has a local view called facility, which apparently copies from the table fac_mas. I added a field into fac_mas, and then the database pretty much went haywire.
>>
>>I get the error message now that "No key columns are specified for the update table "solid!fac_mas." Use the KeyFieldList property of the cursor.
>>
>>Now I am not familiar with local views at all and honestly I can't understand why there is one here. All I did was add one field to the fac_mas table and now this happens. Anyone who is more familiar in this area able to help?
>
>That can happen when you change the struture of a table that a view is using. First thing you will want to do is get the code for the view. If you're having trouble with the view-designer, you can run a program called "Gendbcx.prg" which you can find here: http://leafe.com/dls/vfp What this does is generate another .prg of your database. Open that prg and search for your view name and you will see the code for the view. Now you can take the snippet of code and add your new field to it and run the "create view" snippet and you should be good to go.

Here is utility for one view/table gentable.prg, genview.prg Download #9388