>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
I think only Kevin or another MM wonk is going to be able to address that correctly. I worked exclusively with VFE, and we had very sophisticated remote view support that made working with sql data very easy, but it was not designed to work well with SPs.
I'm sure Kevin could tell you very quickly what approach works best with MM. As I'm sure you realize, using SPs will have the advantage (I think) of less rewrite when you move the app to .NET. (aren't you kind of tempted to do that now?)
Charles Hankey
Though a good deal is too strange to be believed, nothing is too strange to have happened.
- Thomas Hardy
Half the harm that is done in this world is due to people who want to feel important. They don't mean to do harm-- but the harm does not interest them. Or they do not see it, or they justify it because they are absorbed in the endless struggle to think well of themselves.
-- T. S. Eliot
Democracy is two wolves and a sheep voting on what to have for lunch.
Liberty is a well-armed sheep contesting the vote.
- Ben Franklin
Pardon him, Theodotus. He is a barbarian, and thinks that the customs of his tribe and island are the laws of nature.