Welcome to dbFreaks.com!
FAQFAQ      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Truncated Decimal Points

 
   Database Help (Home) -> Visual Basic -> ODBC RSS
Next:  setting Date to Null in Access  
Author Message
Brian W.

External


Since: Dec 09, 2003
Posts: 1



(Msg. 1) Posted: Tue Dec 09, 2003 2:50 pm
Post subject: Truncated Decimal Points
Archived from groups: microsoft>public>vb>database>odbc (more info?)

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

 >> Stay informed about: Truncated Decimal Points 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
HOWTO: Clone SQL db ? - Hi all, I'm having a SQL Server database called X. For testing and training, I would like to make a copy of the entire DB to Y. This copy should include all data, properties, indexes, views, etc. Unfortunately, all my attempts to automate this..

Change connect string for Excel Queries using an ODBC Driver - Reference: ODBC Connection for MAS90 MAS200 In Excel we have an ODBC Connection String with a physical (hard coded) path to the data. We have changed the servers. We do not want to recreate all of the queries. How can we edit the ODBC path inside of..

ISA 2006 with My sql Connection - Hi, Please help me,acutually I am facing problem with ISA 2006.It does not connect Mysql data base. It is giving error"Can't connect to Mysql server on "IP" 10060."

Compile Error - Can anyone please help me to solve this problem I have when I tried to compile and run my program written in VB 6.0? Problem: I used variable declaration such as db as Database and ws as Workspace. I use ODBC way to connect my VB form interface with....

ISAM driver query - Hi, I am developer in Visual Basic 6.0 and SP4 application development and database use MS Access XP and SQL 7.0. This field last 6years and I am use Clipper 5.3, 5.2(Compiler) and Foxpro 2.6, Dbase IV(Database). At now I am totaly convert in VB so I am...
   Database Help (Home) -> Visual Basic -> ODBC All times are: Pacific Time (US & Canada) (change)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]