[RESOLVED] Problem with VBNULL

[VidhiSagare]

If rsAttrib("Description").Value <> vbNull Then
strCondDesc = rsAttrib("Description").Value
End If
Above code is wrttten in vb6.0

Datatype for Column Description is varchar and above code works fine except one case.

If value of Description is “1” then it won’t enter the If block as in visual basic 6.0 VBNULL is enumeration and its value is 1. I want it to execute for 1 also.

Please give me some suggestion.
how can i handle this.

[Merri]

Empty uninitialized string is vbNullString. This is equivalent of NULL in C.


You can also check for empty string by using LenB(strText) = 0 - this is actually faster than checking for vbNullString.

[VidhiSagare]

rsAttrib is recordset. and if the value is Null in Description , if you try to assign it to some variable it gives error. Even finding length won't work in this case.

I tried to compare with vbNullString, but vbNullString is empty string not NULL.

[Merri]

In that case: you're getting a Variant. With Variants you can use:

If IsNull(rsAttrib("Description").Value) Then

You can also find IsEmpty and some other functions that only work with Variants. You can find these by opening up the Object Browser by pushing F2.



(I'm not too familiar with recordsets.)

[VidhiSagare]

Hey Thanks.


It's working