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: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Mon, 15 Nov 2004 10:01:56 +0000
Message-ID: <CWDV2loU6HmBFw$I@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 - 04:01:56 CST

Original text of this message

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