Getting error when checking for ISNULL

[goldi]

I have a VB6 program using a sybase database. I use ADO 2.6 to access the database. When I use the IsNull() on a field from that database (and the field is equal to null) I get an error "-2147024882 (8007000e) Not enough storage to complete this operation". It seems to ignore the fact that the field is Null and tries to use that field and that's when I get the error.

What can I do?

 

[tsdragon]

Try concatenating the field from the database with "" and testing for "" instead of null.

if rs!field & "" = "" then
...

Meddle not in the affairs of dragons,
for you are crunchy, and good with mustard.

 

[Golom]

Instead of the IsNull function, have you tried

    fld IS NULL

?

 

[goldi]

tsdryden: Thanks for the tip. Works great. I thought I had tried that, but must be I didn't do it quite like that, because today it is working and yesterday it wasn't. I wasn't having a problem on my XP machine but the users have Win 2000 machines and they were the ones having the problem.

Thanks for the tips!