SQL VB6.0 & Null Values

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
Whil
Forum Newbie
Posts: 8
Joined: Wed Jul 30, 2003 8:50 am
Location: USA

SQL VB6.0 & Null Values

Post 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 :)
fractalvibes
Forum Contributor
Posts: 335
Joined: Thu Sep 26, 2002 6:14 pm
Location: Waco, Texas

Post 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
Post Reply