Very Computer

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

Recordset.Fields("FieldName").Value

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 ?

Steve

Steve,

Did you try?

if IsNull(Recordset.Fields("FieldName").Value) then
.....
if it is not working, then I think something wrong with provider

--
Val Mazur
Microsoft MVP

Quote:> 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

> Recordset.Fields("FieldName").Value

> 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 ?

> Steve

Unfortunatley , I do not have an IsNull function in Navision Attain 3.6, so
I can't use that code. I have used that method using ASP, VB etc, but I am
looking for a workaround, given that I don't have that function. I am
looking for a method or proprty within ADO 2.7 that could help.

Thanks
Steve

Steve

I assume you code looks something like this:
/* ************************************* */
  _RecordsetPtr rset;
  ...
  _bstr_t myBstr;
  myBstr = rset->Fields->GetItem("FieldName").Value

/* ************************************* */

With that, you would get an exception thown on the null case.
my preference (using VC++) would be something like this:
/* ************************************* */
  _bstr_t myBstr;
  _variant_t myVar  = rset->GetCollect("FieldName")
  if(myVar.vt == VT_NULL) myBstr = L"";
  else
  myBstr = myVar.bstrVal;
/* ************************************* */

regards
roy fine

Quote:> 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

> Recordset.Fields("FieldName").Value

> 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 ?

> Steve