[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

microsoft.public.dotnet.framework.odbcnet

Update real type field with a null?

Grace McMahon

7/24/2002 3:01:00 AM

How can I update/insert a nullable real type field with a null value. My
situation is that I already have a value in the real field which is nullable
and I need to update it to nothing - which is null. No other value is
acceptable.
2 Answers

Tony

7/24/2002 5:10:00 AM

0

Set it to DbNull.

Tony

"Grace McMahon" <gracemcmahon100@hotmail.com> wrote in message
news:O2qx4yqMCHA.2604@tkmsftngp11...
> How can I update/insert a nullable real type field with a null value. My
> situation is that I already have a value in the real field which is
nullable
> and I need to update it to nothing - which is null. No other value is
> acceptable.
>
>
>

Grace McMahon

7/24/2002 6:24:00 AM

0

Does not work. It gives me an error saying cannot put varchar in float type
field.

I am working with Ingres DB. And I pass the value as
system.dbnull.value.

dbnull on its own says DBNull is a type in system and cannot be used as an
expression.

Please help!

Cheers


"Tony" <tonyng2@spacecommand.net> wrote in message
news:uUolV#rMCHA.2368@tkmsftngp10...
> Set it to DbNull.
>
> Tony
>
> "Grace McMahon" <gracemcmahon100@hotmail.com> wrote in message
> news:O2qx4yqMCHA.2604@tkmsftngp11...
> > How can I update/insert a nullable real type field with a null value. My
> > situation is that I already have a value in the real field which is
> nullable
> > and I need to update it to nothing - which is null. No other value is
> > acceptable.
> >
> >
> >
>
>