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: SQL Update Numeric Field

Re: SQL Update Numeric Field

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sun, 28 Nov 2004 12:36:18 -0800
Message-ID: <1101674085.296874@yasure>


Jason Gyetko wrote:

> I have an Access frontend linked to an Oracle backend. When I run an update
> query against a Number field, I have set it equal to "123" instead of 123
> (like it's a Character field). Does anyone know why this is? Do I have
> something configured incorrectly in my field, or is that just the way Oracle
> handles it?
>
> Field Structure
> ---------------
> Name: Item
> Schema: <None>
> Datatype: NUMBER
> Size: 38
> Scale: 0
> Ref:
> Nulls?: Yes
> Default Value: 0

Having not much experience with MS Access I can't tell you whether the problem is MS Access or your ODBC driver but I can tell you that it is not the way Oracle works.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sun Nov 28 2004 - 14:36:18 CST

Original text of this message

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