Array of databases

Databases
#1

I am trying to build a dynamic array of a variety of database objects. Would I be correct in assuming I should delclare the array as a variant

dim dbs(-1) as varient

Then add multiple objects like

dbs.append SQLdatabaseMBS
dbs.append sqllitedatabase

etc etc? not having any luck with this method.

#3

Gawd no not Variants

Since ALL databases are subclasses of Database declare it as an array of Database

dim dbs(-1) as Database

Then add multiple objects like

dbs.append SQLdatabaseMBS
dbs.append sqllitedatabase
#4

I would suggest you rather locate database on a session, webpage/window where it is needed and not in some huge global array.

#9

You get compile errors because array is Database type (I presume). Please try with locale SQLDatabaseMBS variable and later stuff it in your array.

#10