>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,

Why not put the "create sql view ..." in a memo filed in your own table and then use a for 1= 1 to my_sql_server_databases

I use eView myself and it will spit out the code very well for you if necessary. I have not used it with SQL as a back end though?

This would also be a great addition to any app that documments what all the darn views are for. Poplulate a list and use that as an editing / updating system.

__Stephen