Unanswered: SQLDMO: QueryResults::GetColumnString() on BIT, DECIMAL, etc. does not honour NULLs
I'm getting buggy results from SQLDMO against SQLServer2K.
The QueryResults COM class's GetColumnString() doesn't seem to return NULL when it should (i.e. on row & col values that actually contain NULL!). This occurs on BIT, DECIMAL, FLOAT (SMALL)MONEY, REAL and NUMERIC columns, but not on columns of other datatypes.
Has anybody worked around this problem? Is it known to be a bug? I'm using a VS.NET-generated COM Interop wrapper and C#.
Is SQLDMO.Server.ExecuteWithResultsAndMessages() the only way of getting at the server-generated messages (such as "Line 10: error blah blah", or the output of PRINT commands, for example)?