Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » ElevateDB Technical Support » Support Forums » ElevateDB SQL » View Thread |
Messages 1 to 3 of 3 total |
Problem with ROUND and SUM in the same query |
Tue, Oct 19 2010 4:24 AM | Permanent Link |
Josselin | Hi,
I do this query with ElevateDB Manager : SELECT Fournisseur, BtPx, Libelle, SUM(Q) AS Quantite, Pu, ROUND(SUM(Q)*PU TO 2) AS Total FROM Edbtp WHERE LENGTH(Fournisseur)>0 GROUP BY Fournisseur, Btpx There is no problem with this query. Now, I do the same query in my application with a TEDBQuery component with the same data, in the result, the field "Total" is always NULL why ? Thanks for your help Bruno |
Tue, Oct 19 2010 5:39 AM | Permanent Link |
Roy Lambert NLH Associates Team Elevate | Josselin
If you perform the same query in your app and EBDManager and there's a difference then there's a difference in one or more of: the query the data the version of ElevateDB It has to be like that because EDBManager is simply a Delphi application using ElevateDB. Nothing else. In this case my bet would be on the fact that in the data used in your application has some nulls in it Roy Lambert [Team Elevate] |
Tue, Oct 19 2010 8:50 AM | Permanent Link |
Josselin | Roy
I verify that and I use the same version of ElevateDB (2.04 b4) the query is the same ( I do a copy / paste ) the data is the same because I use the same DATABASE Bruno |
This web page was last updated on Saturday, May 4, 2024 at 12:54 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |