Check Null Value

[khinlau]

I do the following code:

_varian_t vValue;
long l;
vValue=pRecordset->Fields->GetItem(_variant_t(0L))->Value;
l=atol((char *)(_bstr_t)vValue);

but when I reach to a record have NULL value in this field, this code will cause an error.
So any body tell me how can I check the vValue was NULL before I call atol function.
Thanks so much.

Khinlau

[HellRiZZer]

You can simply go
if(pRecordset->Fields->GetItem(_variant_t(0L))->Value!=NULL)
{vValue=pRecordset->Fields->GetItem(_variant_t(0L))->Value;
}

[khinlau]

are you sure that code run well?
I can not compile the code if(pRecordset... !=NULL)
and you note that this recordset I use ADO.
Thanks so much for you help
Khinlau