SELECT SUM() FROM...

apve · 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 · 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 · 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 · 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 · 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 · Post by **Dimon** » Wed 14 Jan 2009 09:21

Yes, you should buy the upgrade to DbxMda 4.