>>I have written a PRG that modifys the structure of a table to add a column. This will be run at the client
>>site.
>>
>>There is a view based on the table, which is no invalid. How to I change the view programatically also?
>
>It's not to difficult to do - a good thing to look at is something called "GENDBCX", which you can get here: http://leafe.com/dls/vfp
>
>If you run that against a .dbc - it gives you a .prg version of your .dbc. Once you have that you can take a look at the code it generates and that should answer all your questions about doing something like this.


I'm not entirely sure this is what I'm looking for. Let me elaborate.

I'm the sole VFP programmer on a team of developers. No one else has any VFP experience. We have a client across
town who we are doig changes for.

I'm creating PRG's to modify table structures. This is the same thing you would do with SQL Server - create
scripts to create, update or drop tables at the client site.

Since these changes are effecting tables which have views asscoiated with them, I need a simple solution along
the idea of a script that anyone can run, with little or no VFP experience.