Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Oracle writing zeros instead of NULLs...
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
![]() |
![]() |