Calculations in a TDBgrid

[Jalr2003]

Hi,

I am new to C++ Builder, and I do not know all the jargon just yet, so please bear with me.

I am using a TDBgrid to display the results from a SQL statement. The values I get look like this,

NAME ITEM QTY
-------- -------- ---------
John Screw A 25
Beckie Screw B 12
Joe Washer A 13

The TDBgrid is linked to a TQuery object that uses Oracle ODBC driver.

I want to be able to add an extra row at the end in which I can put comments and/or the sum of the quantities displayed.

The desired results would look like this:

NAME ITEM QTY
-------- -------- ---------
John Screw A 25
Beckie Screw B 12
Joe Washer A 13
TOTAL 50

If I were to use Oracle SQL Plus, I would just set some breaks and computes. However, I cannot incorporate those lines into my sql statement, because I get a syntax error.

How can I accomplish this?

Thanks for your help,

JALR2003