>>>My company is going to be writing a front-end using VFP, shortly, to access an Oracle backend. I'd quite like to use ADO instead of remote views. Any opinions on using this methodology would be gratefully received!
>>
>>Definately ADO. Under MS SQL Server, you get better performance by calling stored procedures for most of your queries, inserts, updates, and deletes. I have to assume that is also true for Oracle. Remote views cannot call stored procedures.
>
>Craig,
>
>What if the system is Grid intensive just like one of ours? Is there a modest way of capturing ADO recordset and displayed in a grid control?
There are several grids that support ADO.
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer