[AccessD] Access Arrays

[Jim Lawrence]

Has anyone done any speed comparisons on collections vs arrays? ...And which Array type perform best and which Array operations are slower (est). Is it better to off-load Array data as text information for some processes?

Jim 

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Tuesday, October 23, 2018 8:08:20 AM
Subject: Re: [AccessD] Access Arrays

Hi Arthur

You can dim it:

Dim MyArray(0 To 99) As Long

All elements will hold a zero.

/gustav

-----Oprindelig meddelelse-----
Fra: AccessD <accessd-bounces at databaseadvisors.com> På vegne af Arthur Fuller
Sendt: 23. oktober 2018 17:00
Til: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Emne: [AccessD] Access Arrays

It's been a while (too long!) since I've done any actual coding in Access, and it seems I've forgotten almost everything I once knew. Case in point:
arrays.

How do I create an array with 100 elements? x = Array(100) gives me an array of one element, not an array of 100 elements.

Also, can I create an array of 100 elements, each of which is a Long?

Your friendly old fart in Toronto.

--
Arthur 

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com