>>I've got a database that has a few remote views defined. Is there an easy way to switch between the connections the remote view uses? I guess I could recreate the remote views for each of the possible connections, but it would be a lot nicer and cleaner for me to just swap connections.
>>
>> Right now I just open the database and USE the remote view. Although the server for the connection needs to change, the data and tables are exactly the same between servers. Ideas?
>>
>>Thanks,
>
>Can you use multiple databases? Just copy the database and edit the connection in each database for the correct datasource.
>
>The just SET DATABASE TO ....
>
>use theview
>
>BOb
I'm going to try Igor's suggestion. If that doesn't work, I think I might try multiple databases. Thanks.
-Paul