Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 2 of 2 total
Thread Error: Aggregate Functions Cannot Be Used Within Expressions
Wed, Mar 8 2006 6:51 AMPermanent 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 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email 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

Image