I am struggling with an issue here using MSADO 2.7.
I am using this code in an IDE that does not have a nice "IsNull" function
( I am using the ERP system Navision Attain 3.60 - if that makes sense to
anyone). Whenever I try and use the
property, I get an error message, stating that the data type is not
supported (this only occurs should the field be <NULL> - I am reading out of
a MS-SQL 2000 db. I am returning the data into a variant type, but for some
reason this does not work.
Is there anyway to check for this before returning the field value.
In essence I am looking for a property or the like that allows me to skip
the offending field should it be NULL. Is there some property I can set on
the connection to avoid this ? Or is it impossible to do ?
Thanks for any help / suggestions ?