SQLSelect into an Array

[Ruslan Zasukhin]

On 9/12/09 11:51 PM, "Barry G. Sumpter" <barrysum at bigpond.net.au> wrote:

> Hi all,
>  
> Is there a way in Valentina to retrieve a Select Query Record Set straight
> into an array?
>  
> I¹ve got a static recordset of about 750 records that I need to loop thru
> about 1000 times.
>  
> So instead of reading the db 750,000 times or looping thru the recordset 1000
> times,
>  
> I thought moving the data into an array would be faster.
> Would looping thru an array be faster?
> Or is looping thru vCursor just another type of an array?
>  
> At the moment I only need 3 fields:  RecID, SequenceID, and EvenName.

The only advice yet.

Put code as

    fld = curs.Field("name")

BEFORE your loop. 
To not get them 750 times .



-- 
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]