I'm currently developing an ActiveX control designed to provide access to a specific database and perform various queries. The purpose of this is to provide our developers with the ability to perform queries without having to worry about SQL queries and such.
My database connects when the DatabaseName property is populated, and I use an enumeration to provide all the available types of queries.
My question really concerns the enumeration. My database has 13 fields and I currently have 19 different options in my enumeration. I find this is a lot and see this list potentially growing. There are so many combinations of fields that could be used to perform queries that I see the enumeration getting out of hand.
However, my control works extremely well and is very easy to use. Everyone is happy with it but I was just wondering if there was a better way of doing it.
Anybody have any ideas?
Thanks,
Yazster
My database connects when the DatabaseName property is populated, and I use an enumeration to provide all the available types of queries.
My question really concerns the enumeration. My database has 13 fields and I currently have 19 different options in my enumeration. I find this is a lot and see this list potentially growing. There are so many combinations of fields that could be used to perform queries that I see the enumeration getting out of hand.
However, my control works extremely well and is very easy to use. Everyone is happy with it but I was just wondering if there was a better way of doing it.
Anybody have any ideas?
Thanks,
Yazster
