Getting "Constant Expression Required" for an Enum 1

[Galford]

I have the following enumeration defined in a class:

'Class module to handle connection to database
Public Enum DBLoc
DBLocal = 1
DBServer = 2
End Enum

From time to time, I'll get a compile error stating Constant Expression Required even though it is defined in the class.

Is this a bug or did I do something wrong? Any help would be appreciated.

Thanks

 

[TerenceOu]

Pls show some code that tells of how you use the enumerators.

 

[Galford]

the following code appears in the loginscreen form:

cCon.ExecuteCommand "qryLogin", rsSecurity, True, cmdSecurity, False, True, DBServer

ccon is a connection class. This is where the enumeration(found in my initial posting) is defined.

This is also the spot where the the program breaks and gives the error. If I hit F8 it jumps to the next spot it finds DBServer and gives the error again.

To fix the problem, I close VB then open it right back up, and it works fine for a while till it decides to do it again.

- Galford

 

[TerenceOu]

Did you close you connection object within your ccon class?

Did you declare the arguement where you pass in "DBServer" as a "DBLoc"?