Hi John,

>Parameters can and should be used whether using SP, SPT, RV, ADO, whatever.

I agree. The more selective you can be about what comes down the wire the better.

>To be clear, you can use parameters in RVs exactly as you do in Local Views.

I agree again.

>In VFP7, RV remains an extremely useful mechanism. Use of the CONNSTRING parameter means you can include a "views" DBC into your application where it will NEVER become corrupt- not that I've ever experienced corruption anyway.

But then you've got to carry around the extra baggage of a DBC. I prefer using a business object that uses SPT to call specific stored procs to retrive records and an ADO Command object to call the appropriate stored procs to update, insert, or delete records.

The business object data class is written generically so it can be subclassed for each specific table. Business rules are coded in the specific business object data class for that table.

I'm sure you're aware of this methodology. I list it for the lurkers who may still be learning.