Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 2 of 2 total |
Error: Aggregate Functions Cannot Be Used Within Expressions |
Wed, Mar 8 2006 6:51 AM | Permanent Link |
Segal Stas | i have a SQl :
SELECT name,vehicleid,productid,productname, SUM(productqty)AS TotalQTY, SUM(meter1-prevodometr) AS deltakm, (SUM(productqty)/SUM(meter1-prevodometr)) FROM (posttransaction LEFT JOIN vehicle ON posttransaction.vehicleid=vehicle.vehicleid) LEFT JOIN product ON posttransaction.productid=product.productid GROUP BY vehicleid,productid It run successfuly when i open it in DBSys utility , but , when itry open it inside my application i got message Error: Aggregate Functions Cannot Be Used Within Expressions can you explain what is reason to error and how i can solve it? Segal Stas Attachments: Clipboard01.jpg |
Wed, Mar 8 2006 12:22 PM | Permanent Link |
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com | Segal,
<< It run successfuly when i open it in DBSys utility , but , when itry open it inside my application i got message Error: Aggregate Functions Cannot Be Used Within Expressions can you explain what is reason to error and how i can solve it? >> You're compiling with a different version of DBISAM than what DBSYS is using. Aggregate expression support was added in a fairly recent version of 4.x. Check your Delphi IDE's Library Search Path and Project Search Path and make sure that both are pointed to a directory with the most recent version of DBISAM. -- Tim Young Elevate Software www.elevatesoft.com |
This web page was last updated on Thursday, March 28, 2024 at 06:18 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |