PostgreSQL

Clínica Cardiológyca C. Costantini

Delphi Developer

Sat, 06 Mar 2004 20:46:03 GMT

SQL function sum does not work with ADO/PostgreSQL

I am using the following SQL command:
'select sum( pacons_quant_consumo ) as soma_consumo from paciente_consumo'
and ADO return only null values, this command work fine with BDE.
Does anybody now whats going on?

Rafael dos Santos

Floe

Delphi Developer

Sun, 07 Mar 2004 07:31:34 GMT

Re:SQL function sum does not work with ADO/PostgreSQL

Clnica Cardiolgyca C. Costantini <clini...@clinicaconstatini.com.br>
schreef in berichtnieuws 3ba741f2_2@dnews...

Quote

> I am using the following SQL command:
> 'select sum( pacons_quant_consumo ) as soma_consumo from paciente_consumo'
> and ADO return only null values, this command work fine with BDE.
> Does anybody now whats going on?

To me this seems perfectly correct (I do the same thing, with shorter
names). Can you give more info?

Floep

Other Threads

1. SQL Cast function does not work with Oracle

2. How work function SUM ???

3. QR 1.1, TQRDBCalc Sum Function Not Accurate

4. SQL-function SUM on a calculated field?

5. Sum & Avg SQL functions

6. Problem with Local - SQL SUM() function

7. Trapping BDE exeptions & SQL Sum function

8. Problem with SQL-SUM function

9. SQL using SUM aggregate function

10. RE ADO working in WIN 9X -not working on WIN2000 PROF