Board index » delphi » Sum & Avg SQL functions

Sum & Avg SQL functions

Hi,

Can I use Sum & Avg & other SQL funtions on local Paradox or Dbase tables
in Delphi 1?

Thanks in advance,

Homayoun

 

Re:Sum & Avg SQL functions


Should be able to use any SQL statement (if supported by local SQL) in a
TQuery component which points to a file-based database, like Paradox or
DBase.  SUM() and AVG() are supported by local SQL (I believe).

Quote
> Homayoun Afshar <hafs...@gpu.srv.ualberta.ca> wrote in article

<31DDA56F....@gpu.srv.ualberta.ca>...
Quote
> Hi,

> Can I use Sum & Avg & other SQL funtions on local Paradox or Dbase
tables
> in Delphi 1?

> Thanks in advance,

> Homayoun

Other Threads