Devart Forums

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

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.

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

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

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

Yes, you should buy the upgrade to DbxMda 4.