Truncated Decimal PointsThis is a discussion on Truncated Decimal Points within the ODBC forums in Framework and Interface Programming category; I am testing a query in Visual Basic's Data Environment designer. The returned information includes "currency" data. When I run a group by, SUM on the currency value, it calculates the total amount correctly. If I leave it as a normal select statement, showing all values, it is truncating decimal values when it ends with ##0.00. For Example: 110.00 = 11 210.00 = 21 90.00 = 9 This appears consistent. When running the same query in microsoft Query or in Access (via the same ODBC connection) I am not seeing the errors. Nor does the problem present itself in the ... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
12-09-2003, 02:51 PM
| |||
| |||
 Truncated Decimal Points I am testing a query in Visual Basic's Data Environment designer. The returned information includes "currency" data. When I run a group by, SUM on the currency value, it calculates the total amount correctly. If I leave it as a normal select statement, showing all values, it is truncating decimal values when it ends with ##0.00. For Example: 110.00 = 11 210.00 = 21 90.00 = 9 This appears consistent. When running the same query in microsoft Query or in Access (via the same ODBC connection) I am not seeing the errors. Nor does the problem present itself in the adodb.recordsets i'm using, though it does in VB. does anyone else have any knowledge to lend on this subject? -Brian  |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -5. The time now is 06:15 AM.
