Visual Basic 6 data structures

Question

What are all the build in data structures for VB6 (Microsoft Access) ? I know there are arrays, but are there other more modern data structures?

Answer 1

It has a Dictionary: http://stackoverflow.com/questions/915317/does-vba-have-dictionary-structure/915323

And Collection: http://stackoverflow.com/questions/76882/vba-resource-for-python-programmer

Answer 2

Disconnected recordsets can also be useful: http://stackoverflow.com/questions/226978/syncing-two-lists-with-vba

Answer 3

You can also create your own (better accessibility/performance XML collections) in this way:

MS XML Collections

Also consider using hashtables:

Hash Tables

Answer 4

The excellent book Hardcore Visual Basic by Bruce McKinney includes some code for creating linked lists, stacks, etc. as part of its introduction to object-based programming with VB6. The book is now available free online.

Answer 5

I don't think I understand the question. When I read it, I thought of:

• Arrays
• Collections
• Types
• Enums

and so forth. Not sure if I'd consider standalone class modules as part of the answer, as they can have any structure you want, rather than being a particular data structure. And, of course, VBA being COM-based, it can use any data structure from compatible COM objects. This may or may not require a type library (depends on the COM object's implementation).

Answer 6

I written quite a lot of code in VB6 and for sure I used Dictionary and Collection classes a lot. But I still think that they are not enough in many cases, that's why I advise you to take a look at this library:

http://sourceforge.net/projects/vbcorlib/

that it's a port of .NET libraries to VB6.