Multiple database cursors...

[Burke Squires <burke at airmail dot net>]

Hi All,

Does anybody have some insight on using multiple database cursors. I would idealy like to use on ODBC connection (in this case MS SQL Server 2000) for multiple Selects, Inserts, etc. What if I have a cursor I am looping through and at each row I want to insert a result into the database? Many times I get a EOF issued with cursor.MoveNext because RB thinks there are multiple people accessing the same records.

Thanks in advance.

Burke

-- 
Burke Squires
Scientist-Bioinformatics
Eliance Biotechnology
9750 Royal Lane #404
Dallas, TX 75231 USA
Home: 214-503-9712
Mobile: 214-394-4882
burke at airmail dot net
www.burkesquires.com