Roll your own SQL and give up on the REABasic API's
This'll allow you to use multiple cursors.
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
--
Cheers,
Dr Gerard Hammond
MacSOS Consulting, 16 O'Donnell Ave, Guyra, 2365 NSW, Australia
macsos at macsos dot com dot au Ph 0414 796 709 http://www.macsos.com.au
PGP: 5DA2 E5A1 0549 9DDD A7F5 8D8E 65B4 D406 EB1A 63C1
Create Like a God; Command Like a King; Work Like a Slave.
|