Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Changing remote-view connection
Message
From
11/04/2007 12:12:38
 
 
To
11/04/2007 12:05:09
Alan Harris-Reid
Baseline Data Services
Devon, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP1
Miscellaneous
Thread ID:
01214484
Message ID:
01214489
Views:
11
>I am creating a new database container based on an existing .dbc, but to save 'reinventing the wheel' I have copied the MyOldDBC.dbc/dcx/dct files to MyNewDBC.*, deleted unwanted views and created new views as required.
>
>My problem is that I would like to use many existing remote views, but change the connection name to point to a different back-end database, but the connection name appears to be readonly. Is there any way to change this, using DBSETPROP() perhaps?
>
>I have looked at the .dbc in browse mode, but I cannot see anything I can change - it looks as if the connection information has been compiled into the Property memo field.
>
>Any help would be appreciated.
>
>Alan

Did you try RENAME CONNECTION ...?
Edward Pikman
Independent Consultant
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform