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
