SELECT SUM() FROM...

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for MySQL in Delphi and C++Builder
Post Reply
apve
Posts: 3
Joined: Tue 18 Nov 2008 23:02

SELECT SUM() FROM...

Post by apve » Tue 18 Nov 2008 23:16

I'm using the next

SELECT *,(SELECT SUM(nprod) FROM vtagar WHERE vtagar.num_vta = ventas.num_vta) as SUMG,
(SELECT SUM(nprod) FROM vtabot WHERE vtabot.num_vta = ventas.num_vta) AS SUMB
FROM ventas

the answer en Mysql 5.0.18 there is not problem, but whe I using this quetion en delphi lite 10 for microsotf windows no function

Whats the problem with SUM
check:
select SUM(columna) from table
what 'up with the SUM

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 19 Nov 2008 15:42

I could not reproduce the problem.
Please send me a complete small sample at dmitryg*devart*com to demonstrate it, including script to create and fill table.
Also supply me the exact version of DbxMda.

apve
Posts: 3
Joined: Tue 18 Nov 2008 23:02

Post by apve » Fri 05 Dec 2008 16:12

Dimon wrote:I could not reproduce the problem.
Please send me a complete small sample at dmitryg*devart*com to demonstrate it, including script to create and fill table.
Also supply me the exact version of DbxMda.

hi, the version is 2.70 corelab and I tryed with 3.oo there is same problem. Now I try with Mysql 4.1 and corelab 2.70 and is working correctly with the same consult (Selec SUM), therefor , Corelab 2.70 not support mysql 5.0, ok

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Tue 09 Dec 2008 08:54

This problem was fixed in the current DbxMda version (4.40.12). You can upgrade to DbxMda 4 to solve the problem.

apve
Posts: 3
Joined: Tue 18 Nov 2008 23:02

Post by apve » Tue 13 Jan 2009 22:39

Dimon wrote:This problem was fixed in the current DbxMda version (4.40.12). You can upgrade to DbxMda 4 to solve the problem.

Do I have to buy the upgrade DbxMda 4, because I have the DbxMda Version 2.70
or there is other option

Dimon
Devart Team
Posts: 2885
Joined: Mon 05 Mar 2007 16:32

Post by Dimon » Wed 14 Jan 2009 09:21

Yes, you should buy the upgrade to DbxMda 4.

Post Reply