Fast reading?

[Thomas Flemming]

Hi,

to write large amount of data into the database there is:

"INSERT INTO [mytable] (f1, f2, f3, ... ) VALUES ( :1, :2, :3, ...)"

which is very fast.

Is there also something similar to READ all fields of a record very fast into 
an array of objects?

I'm still doing

cursor.Position = i
f1 = cursor.fields("f1").value
f2 = cursor.fields("f2").value
f3 = cursor.fields("f3").value
...


which is quiet slow...

Regards,
Tom

-- 
/****************************************
**   Dipl.-Ing. Thomas Flemming
**   Software Development
**
**   Touratech AG
**   Auf dem Zimmermann 7-9
**   D-78078 Niedereschach
**
**   mail  tf at ttqv.com
**   fon   +49 (0) 7728 9279-206
**   fax   +49 (0) 7728 9279-29
**
**   http://www.ttqv.com
**   http://www.touratech.de
**
**   ... und immer dem Pfeil nach!
***************************************/