dave_duke
(dave duke)
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.
Norman_P
(Norman P)
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
I would suggest you rather locate database on a session, webpage/window where it is needed and not in some huge global array.
You get compile errors because array is Database type (I presume). Please try with locale SQLDatabaseMBS variable and later stuff it in your array.