>I'm a relative newbie when it comes to dealing with SQL Server and I've run into a problem that I thought someone here might be able to help with.
>
>I'm working with some folks on a new system where the data is being stored on SQL Server 7.0 in six different databases. Of these, 5 contain the same tables. The 5 represent 5 different manufacturing facilities. As a result I've created VFP databases containing remote views to the tables.
>
>The problem is that because the system is still under development, the underlying table structures are subject to change. This wouldn't be a big deal if I didn't have to go through the process of updating the individual views 5 times. Is there any easy way to programmatically do this? Right now, I have to manually modify the view and save the changes in order to update it. I'm just looking for something simpler that I could knock out a couple of lines of code to do this.
>
>tia,

Hi George,

You may generate the code for your remote views with GENDBC.PRG (I think some of view utilities on UT generate the full code for the selected view too.), and then update the code and re-run it when needed to recreate the view.