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 (ie adding a field). 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