Fast reading?

[Ruslan Zasukhin]

On 4/10/10 12:48 PM, "Thomas Flemming" <tf at ttqv.com> wrote:

> 
> Its not filling another table, I just need them into a .net-object/variable.
> And so I'm doing
> 
> for i =0 to cursor.recordcount
>    cursor.Position = i
>    f(i).a1 = cursor.fields("f1").value
>    f(i).a2 = cursor.fields("f2").value
>    f(i).a3 = cursor.fields("f3").value
> next

Not ideal loop :)

Count = cursor.recordcount
For I = 1 to count

Btw, position of cursor from 1  must be

Even better loop

Curs.FirstRecord

Do
  ...

While curs.NextRecord()




-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]