Subj : ADO giving Invalid Variant Type Conversion
To   : borland.public.cpp.borlandcpp
From : "Russell Allen" <russell.allen@bt.com>
Date : Tue Dec 23 2003 04:39 am


Hi all,

I'm just dipping my toe into using ADO through CBuilder, and so far it's gone fine - until I try and access fields from a recordset that are empty.  If I try and convert these fields to an AnsiString data type to display on screen, I get an EVariantError, "Invalid variant type conversion".  And I can't find any way to determine whether these fields are going to convert okay - their type is 9, which I think means string, their sizeof is 16 bytes, the same as a valid field seems to be.

So when I'm reading strings from a recordset, how do I avoid this error message if a field is empty?  Hope this makes sense!

Russ

.