Re: Access VB6 sum bug

From: polym (mymail_at_nospam.com)
Date: 01/24/05 

Date: Mon, 24 Jan 2005 10:58:43 +0200

If i use same numbers, same bug exist in MSSQL Server 2000 (With sp3) .

"Veign" <NOSPAMinveign@veign.com> wrote in message
news:uUT2pnl$EHA.208@TK2MSFTNGP12.phx.gbl...
> I can't reproduce any errors when summing multiple fields. What are the
> data types of the fields in question?
>
> --
> Chris Hanscom - Microsoft MVP (VB)
> Veign's Resource Center
> http://www.veign.com/vrc_main.asp
> --
>
> "polym" <mymail@nospam.com> wrote in message
> news:O25orkk$EHA.2016@TK2MSFTNGP15.phx.gbl...
> > I am using access database.
> > If i open access database and execute that query there is no problem.
> > But if i execute that query from vb6 i got incorrect results.
> >
> > Here is my query :
> > SELECT SUM (a - b - c + d) as fark FROM mytable where mytype=1
> >
> > I know that
> > Sum of a is 0 , sum of b is 0 , sum of d is 0.
> > sum of c is 3.
> > But in vb result is 11.
> > No meaning.
> > Like i said before if i execute query in access it results 3. ok.
> > But incorrect result in vb6.
> >
> > If i execute SELECT SUM (a) , sub( b ) , sum( c ) , sum( d) FROM
mytable
> > where bytype=1
> > in vb6 i got sum(c) as 3.
> >
> > I habe vb6 with sp6. Operating system : windows 2003 enterprise server.
i
> > applied online windows update.
> >
> > I am using MDAC 2.7 sp1.
> >
> > Did you get any bug like this?
> >
> >
>
>

Loading