Return Multiple Types from Function
Posted on 2006-07-13
Is it possible to write a function that would return values of multiple types, depending on input, and if so, how? This is what my newbie-brain came up with...
Function GetKeyValue(Key(s), DataType) as ???
Dim x as integer
Dim y as single
Dim z as string
--- get key value from DB using Key(s), and based on Type indicated in DB, recast or select it into either x, y, or z
If Datatype = "INT" return x
If Datatype = "SGL" return y
if Datatype = "STR" return z
Any guidance on this would be appreciated.