Vlad,

Thanks for the response!

This sounds like it would be a great tool that would give you quite a bit of control over the data. The only issue I would have is inputing the view data into the table. Did you do this manually or did you write a prg that would do it automatically?

Thanks!

-Justin

>Hi!
>
>We made for this purpose a special table that holds all SELECT stameents and properties for every view. Then we just run a program to re-create all views. Searching for certain table and alter queries now becomes much easier. Also, you can create this way views that could not be created normally by view designer because special query string.
>
>>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