>We're starting a new VFP/SQL Server project and have been discussing the benefits/pros & cons of using remote views versus SQL passthru. We'd be interested in any opinions on this debate and experiences from your point of view and work you've done/are doing.
>
>By the way, this will be done ourselves, we're not interested in a framework or "tool" to do this for us. :)
>
>Thanks.


>You can't call stored procedures via Remote Views. You also don't have control >over transaction handling.

So, are those the two things that make passthru "better" than remote views, or are there other reasons to go the passthru route. We realize that you can do both, but is there a strong case to be made for using passthru when dealing with the development of forms, that is create cursors in the LOAD and do passthrus to populate those cursors for the controls, OR just use remote views and set the control sources of form controls to the view? Is there a benefit to doing the passthru method in this context, while having to do more code, rather than remote views?