>>>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?
Jess,
Check out my RS to cursor routine in the UT downloads (ADOGetrows.jcRstoCursor). It is faster than the original rs2dbf (available from MSKB) but slower than VFPCOM. The advantage is that you have the source code.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only