Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: SQL Update Numeric Field
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