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

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