>We are converting a VFP 9.0 application with the Mere Mortals framework to SQL Server. Using Visual FoxPro as a front end, would it be better to use Stored Procedures or Remote Views to access the data through SQL Server? Is there a built-in method in the framework to access data using Stored Procedures?
>
>Jerry
Jerry,
I was thinking yesterday about this problem. I think if you want to go with minimal changes in the existing application, you can switch most of the local
views to remote views.
Otherwise I'd go with CAs and stored procedures.
If it's not broken, fix it until it is.
My Blog