![]() | ![]() Products ![]() ![]() ![]() ![]() |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB General » View Thread |
Messages 1 to 10 of 10 total |
![]() |
Sun, Jan 20 2008 11:37 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | 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 |
Sun, Jan 20 2008 12:00 PM | Permanent Link |
"Harry de Boer" | 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 |
Sun, Jan 20 2008 3:42 PM | Permanent Link |
"Fons Neelen" | 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 |
Mon, Jan 21 2008 2:23 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Fons
Your's makes sense - Harry go sleep it off ![]() Roy Lambert |
Mon, Jan 21 2008 4:42 AM | Permanent Link |
"Harry de Boer" | 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 > |
Mon, Jan 21 2008 5:08 AM | Permanent Link |
Roy Lambert NLH Associates ![]() | Harry
Bloody good idea. Roy Lambert |
Mon, Jan 21 2008 8:11 AM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Mon, Jan 21 2008 12:41 PM | Permanent Link |
Fernando Dias ![]() | 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 |
Mon, Jan 21 2008 1:02 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. ![]() | 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 |
Tue, Jan 22 2008 5:58 AM | Permanent Link |
Fernando Dias ![]() | 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 |
This web page was last updated on Monday, July 15, 2024 at 07:03 PM | Privacy Policy![]() © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? ![]() |