Using Stored Procedures and RDO

[campbere]

I want to improve the performance of my vb application when it generates information for a report. In the procedure to return the information that is needed I use two rdo recordsets, and I write information out to txt files multiple times.

Another programmer suggested that I use a stored procedure on the database side rather than querying from the client side. I looked at MSDN library for help with RDO and stored procedures and I didn't understand much of it.

Does someone know of a good source for this? Or can someone outline the basic steps.

Thanks

 

[culshaja]

I would buy the ADO 2.6 Programmers Reference by Wrox as it has a good section on RDS. You could also look at somewhere like

http://www.mcpcentral.com

or

http://www.asp101.com

for examples.

James James Culshaw
jculshaw@active-data-solutions.co.uk

http://www.active-data-solutions.co.uk

http://www.brainbench.com/transcript.jsp?pid=193305