After experiencing a lot of down time, We decided to move this site to
CrystalTech.com. CrystalTech.com is powered by only the finest Windows servers providing the best performance, reliability, and value anywhere.
can't store correctly a double in Access
|
Author |
Message
|
caifa
-
Total Posts
:
3
- Scores: 0
-
Reward points
:
0
- Joined: 12/3/2009
-
Status: offline
|
can't store correctly a double in Access
Thursday, December 03, 2009 4:38 AM
( permalink)
Hi folks! I can't store correctly a "double" into an Access database (I'm using ASP/Vbscript). Specifically I have a variable, with 2 decimal places: foo = FormatNumber(CDbl(10,60),2) I want to insert this variable in Access in a field with type Number, Field Size Double and 2 decimal places. The INSERT statement executes without any error, but when I query the table I see 1.060,00 instead of 10,60!!! I've tried to set the data type to "Currency" or to set the field size to "Decimal", but neither works... How can I solve this mistake? Any help would be appreciated!
<message edited by caifa on Thursday, December 03, 2009 4:40 AM>
|
|
|
|
caifa
-
Total Posts
:
3
- Scores: 0
-
Reward points
:
0
- Joined: 12/3/2009
-
Status: offline
|
Re:can't store correctly a double in Access
Thursday, December 10, 2009 9:23 PM
( permalink)
Anyone could help me on this... Please!
|
|
|
|
Online Bookmarks Sharing: