Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle writing zeros instead of NULLs...

Re: Oracle writing zeros instead of NULLs...

From: Sean <seanm555_at_nospam.msn.com>
Date: Mon, 15 Nov 2004 08:16:56 -0700
Message-ID: <daydne09MIj0VQXcRVn-pQ@comcast.com>


No default value on the column, NULLs allowed.

"Jim Smith" <jim_at_jimsmith.demon.co.uk> wrote in message news:CWDV2loU6HmBFw$I_at_jimsmith.demon.co.uk...
> In message <vKKdnUbz3tKn6gXcRVn-gg_at_comcast.com>, Sean
> <seanm555_at_nospam.msn.com> writes
> >Hello all,
> >
> >Something weird is happening at a client site, where I have no control
over
> >the oracle 8,9 servers my application uses to communicate (via ADO) with,
so
> >I don't have the ability to look directly at the schema. I can request
> >information about the schema that would be relevant, so that's why I'm
here
> >trying to figure out where to look for a solution. The client is running
> >Oracle server version 9, and is being accessed with the client driver 8.
I
> >have a number field that's being accessed with an ADO recordset, that's
> >bound in a VB application to a grid control. The grid control writes
back
> >NULL when the cell is empty, and this functionality has been verified on
a
> >different Oracle 8 server. On the Oracle 9 server, a zero ('0') is
written
> >to the field instead of NULL, which I can't explain. Why is a zero being
> >written to the number field instead of NULL? Thanks,
>
> Does the column have a default specified?
> --
> Jim Smith
> Because of their persistent net abuse, I ignore mail from
> these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
> For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Mon Nov 15 2004 - 09:16:56 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US