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,
George
Ubi caritas et amor, deus ibi est