Oracle Data Types

[James]

Does anyone know of a fix to link Oracle table in
Access97 where the field types change from Number(24,9)
to Text(255). I need these field to be Number(Double) in
access not text.

 

[TC]

Does anyone know of a fix to link Oracle table in
Access97 where the field types change from Number(24,9)
to Text(255). I need these field to be Number(Double) in
access not text.

From the dim past, doesn't Oracle NUMBER(24,9) mean: " a number with up to
14 digits to the left of the decimal point, and up to 9 to the right"?
(14+1+9=24)

If so, how will that fit in a Double? Double is a "whole number" data type.
It does not allow *any* digits to the right of the decimal point.

I'm sure there is an article on the microsoft website somewhere, which
compares the Oracle databtypes to Access/Jet. Perhaps do some googling...

HTH,
TC

 

[Tim Ferguson]

If so, how will that fit in a Double? Double is a "whole number" data
type. It does not allow *any* digits to the right of the decimal
point.

No: a double is a double precision float, and should contain this size of
real number easily. You may be thinking of a long, which is a 32-bit
integer.

The answer to the question is either (a) to use a view or a query to coerce
the values:

select this, that, theother, cdbl(numberfield) as realnumberfield
from thetable
etc.

or, if you are importing the table, to create an empty table first with the
correct data types and append the incoming to it.

Hope that helps


Tim F