I know, its a bit weird, but I'm reading the manual

Can someone explain this

<<If the precision is not specified, then the default is 19-20 digits.>>

Does this mean the precision is either 19 or 20 and if so how does ElevateDB decide?

Roy Lambert

Roy

Before 2000 it was 19 and now it is 20

I Knew there was something in the deap grey matter in my head that was
famialour with the combination of keywords 19, 20 and digits

Regards, Harry


"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:46FD4983-33B9-4457-BC77-0BD53C15E98B@news.elevatesoft.com...
> I know, its a bit weird, but I'm reading the manual
>
> Can someone explain this
>
> <<If the precision is not specified, then the default is 19-20 digits.>>
>
> Does this mean the precision is either 19 or 20 and if so how does
ElevateDB decide?
>
> Roy Lambert

Roy,

> <<If the precision is not specified, then the default is 19-20 digits.>>
>
> Does this mean the precision is either 19 or 20 and if so how does
> ElevateDB decide?

I am not quite sure, but as far as I know it depends on whether the number
is positive or negative. If negative then the precision is 19.

Fons

Fons


Your's makes sense - Harry go sleep it off

Roy Lambert

Roy,

I will do that. If I sleep long enough then the digits can be 21 too

Harry


"Roy Lambert" <roy.lambert@skynet.co.uk> schreef in bericht
news:111247EB-B8EA-4368-8E38-C585B7200C36@news.elevatesoft.com...
> Fons
>
>
> Your's makes sense - Harry go sleep it off
>
> Roy Lambert
>

Harry


Bloody good idea.

Roy Lambert

Roy,

<< Does this mean the precision is either 19 or 20 and if so how does
ElevateDB decide? >>

As Fons indicated - it's the sign that determines this.

--
Tim Young
Elevate Software
www.elevatesoft.com

I suppose you are talking about Numeric/Decimal types...
To me, the question is not how does EDB decides between 19-20 digits but
how can any 20 decimal digits value be stored if even
999999999999999.9999 (19 digits) can't be stored!
It seems it should be 18-19 digits, not 19-20.

--
Fernando Dias
Easygate, Lda

Fernando,

<< I suppose you are talking about Numeric/Decimal types... To me, the
question is not how does EDB decides between 19-20 digits but how can any 20
decimal digits value be stored if even 999999999999999.9999 (19 digits)
can't be stored! It seems it should be 18-19 digits, not 19-20. >>

The Delphi manual refers to the Currency type as having a possible 19-20
significant digits, depening upon the sign.  However, it appears that they
are including the decimal point, and that probably isn't correct.  I'll get
this corrected in the manual.

--
Tim Young
Elevate Software
www.elevatesoft.com

Hello,

For "Currency" type the scale is always 4, so the range of valid values
is -922337203685477.5808
to 922337203685477.5807 ( 2^63 -1 to 2^63  , divided by 10000).
The way I understand it, the number of digits does not depend on the sign of
the number. To me, 18-19 digits mean all values with 18 decimal digits can
be represented and some, but not all, with 19 digit can also be represented,
so 18 to 19 digits. This is only the way I interpret this, of course.

For Numeric/Decimal column types, we can specify a scale from 0 to 4, so if
those types are implemented as Currency, this means we can have 14 to 19
decimal digits, depending on the scale. I don't know how are this column
types implemented - only Tim can confirm this (or not) ...

--
Fernando Dias
Easygate, Lda