Is there a way to programmatically change the DataSource of a Remote connection? I have a bunch of views set up that access a Connection to an Oracle database. I don't want to have to duplicate the views just to change the connection name from the one pointing at the production DSN to the one pointing at the test DSN. The application I'm working with has both a production and a test environment for regular Fox tables, but this is the first time we've added remote data (which also has a production and a test environment) into the mix.

TIA!

Laurisa Watkins