If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Why won't Single take my number?
I have a field with NUMBER datatype, SINGLE field size, Fixed format and 0
Decimals. When I enter the value 100317090407 the number rewrites itself as 100317100000. When I enter 100317090417 again I get 100317100000. When I enter 100317090499 once again I get 1003617100000. My number is clearly under then max for a Single 3.402823E38, so what is going on? If I set my field size to DOUBLE, I do not encounter the same problem, but I don't get it. Why do my numbers seem to have a mind of their own with the SINGLE field size? |
Thread Tools | |
Display Modes | |
|
|