>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.

Both have their good points and bad points. Personally I prefer to use SPT when possible because (1) you don't have to have a DBC, (2) you can send commands straight to SQL (either dynamically built statements or calls to stored procedures), and (3) they are often (but not always) faster. As far as I'm concerned, SPT offers the developer an incredible amount of flexibility, something I wouldn't want to give up.

Remote views, on the other hand, are useful if you have to present groups of records to the UI, such as in a grid. RV reaction time has been greatly enhanced, but you still are bringing data to the client every time you want to do any kind of operation. Also, they can be a PITA to work with when adding new records, because you are adding info on the client side - none of your DB-bound defaults will fire UNTIL you insert the record.

HTH - Dan