SQL using SUM aggregate function

Robert Case

Delphi Developer

Tue, 03 Mar 1998 03:00:00 GMT

SQL using SUM aggregate function

Has anyone had any luck using "SUM" in an SQL query. My SQL
looks like this....

SELECT SUM(FLD_NAME)
FROM TABLE
WHERE TABLE_KEY = :key

When I activate the query I get an error saying....

Field "SUM of FLD_NAME" not found

Any ideas/examples would be appreciated cause I'm stumped.

--
Robert Case
Certified Netware Engineer (CNE)
Home http://www.teleport.com/~rcase/

Todd Fa

Delphi Developer

Wed, 04 Mar 1998 03:00:00 GMT

Re:SQL using SUM aggregate function

In article <43atuf$...@maureen.teleport.com>, rc...@teleport.com says...

Quote

>Has anyone had any luck using "SUM" in an SQL query. My SQL
>looks like this....

> SELECT SUM(FLD_NAME)
> FROM TABLE
> WHERE TABLE_KEY = :key

>When I activate the query I get an error saying....

> Field "SUM of FLD_NAME" not found

>Any ideas/examples would be appreciated cause I'm stumped.

You need to surround the field name with quotes. You may also need the table
reference prefixing the field name.

Todd
--
=======================================================
Todd Fast
"His mind is somewhat too much taken up with his mind." - John Earle
Author of ReportLink, Paradox automation and report printing
component for Delphi.
=======================================================

Other Threads

1. Local SQL - using SUM function

2. SQL Aggregate Sum

3. Fatal exceptions when using sub-querys containing aggregate functions

4. access violation when using aggregate functions in ADO/Access 97

5. Using MAX as aggregating function

6. SQL - aggregate functions and groups

7. Aggregate functions and Group By problems in Local SQL

8. Aggregate functions in SQL

9. Newbie: SQL Aggregate Functions????

10. SQL Aggregate Function Help