Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Updating remote FoxPro views.
Message
 
To
All
General information
Forum:
Microsoft SQL Server
Category:
Database management
Title:
Updating remote FoxPro views.
Miscellaneous
Thread ID:
00700915
Message ID:
00700915
Views:
72
Hello,

Currently we are using a VFP7 front to our SQL Server 2000 back end. Our application updates the SQL Data through FoxPro remote views stored in a corresponding VFP database.

Before we switched to a SQL back end, we used Stonefield to update all of our views dynamically whenever we changed the structure of a VFP table. That no longer works with SQL data. We still use Stonefield, but in a much more laborious way; We now have to open the DBC, scroll through every view (over 500) for a reference to the altered table and redefine it. We then use eViews to generate a script for the view, then run that script for all of our DBs (about 15).

There has got to be a better way of doing this. Does anyone know of a product that can automatically find and fix VFP remote views in a VFP DBC whenever the corresponding SQL DB has a table alteration?

Your help is VERY appreciated.

-Justin
Reply
Map
View

Click here to load this message in the networking platform