Bingo.

There is the "CRUD" concern for server databases. That is, you wanted consistent access to creation,retrieval,updating,and deletion of data. Placing these functions in a data services tier comprised of SPs guarantees consistency and greatly reduces the chance of deadlocks.

Theer are other advantages as well: Stored procs are precomped, re-entrant, and if your data access bogs down, you have access to server management tools for both the database server's hardware and the server database.

>One of the big advantages I see of SP's vs. RV's, that I haven't seen mentioned yet, is that RV's are a VFP only mechanism. If you need to access the data from other non-VFP applications you're going to need the SP's for the other applications anyway.