SQL VB6.0 & Null Values
Posted: Tue Oct 21, 2003 2:31 pm
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
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