Page 1 of 1

SQL VB6.0 & Null Values

Posted: Tue Oct 21, 2003 2:31 pm
by Whil
Hi,
I am hoping that some of you could help me out. I am trying to copy a database from 97 format to 2000 format in VB 6.0. When I try to copy infromation taht is null from the 97 into the 2000 i get "invalid use of null". How can i fix this? If i do
if isnull (rs!thingy) then
rs!thingy = 00
end if
eventually it comes up with the error "number of rows pending exceeds the limit"

-Thanks for your help
-Whil :)

Posted: Tue Oct 21, 2003 9:46 pm
by fractalvibes
I gather you are dealing with Access? Anyway, perhaps an idea is to update all your null columns with a space?
Update sometable
set somecolumn = " "
where somecolumn = null

Been a long while since I dealt with Access, so my syntax may be a little dodgy, but you get the idea.

Thinking that if you just open an Access 97 mdb with Access 2000 it will take care of things behind the scenes in its conversion to 2000 format...

fv