StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » Enums and SmallInt

Enums and SmallInt

Bill Cunnien — Mon, 14 Jan 2008 18:25:52 GMT

I was having trouble getting an enum type to work properly on one of my business objects. The DB type was smallint. I kept getting 'specified cast is invalid'. Of course, I kept thinking I was doing something wrong. Then, on a whim, I changed the DB type from smallint (int16) to int (int32) and the enum type now works without errors.

Can someone please confirm that a smallint data type will not work with enumerations in StrataFrame?

Thanks,
Bill

RE: Enums and SmallInt

Bill Cunnien — Mon, 14 Jan 2008 18:25:52 GMT

Excellent! Thank you!!

RE: Enums and SmallInt

Trent L. Taylor — Mon, 14 Jan 2008 17:19:27 GMT

[quote]Can someone please confirm that a smallint data type will not work with enumerations in StrataFrame? [/quote]

This is not StrataFrame...this is .NET. You can define an enum several different ways, but if you do not implicitly define the integer type, then it assumes Int32. So yes, it is generally best to use an Int32 for Enums:

Public Enum MyEnum As Integer - Implied if left off