Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Remote Views vs. Stored Procedures
Message
General information
Forum:
Microsoft SQL Server
Category:
Database design
Miscellaneous
Thread ID:
01496772
Message ID:
01496850
Views:
45
>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
Previous
Reply
Map
View

Click here to load this message in the networking platform