Board index » delphi » To sum a TDBGrid Colum programmaticaly while editing in a TDBGrid

FONKOU Barthélémy

Delphi Developer
Sat, 23 Apr 2005 18:56:10 GMT

To sum a TDBGrid Colum programmaticaly while editing in a TDBGrid

Is there a way to calculate the sum of a numeric column for a TDBGrid while
editing this DBGrid ? I want that if the user change the values of one row
of this column, the the values of the total sum of this column changes also

I use Delphi 5 and SQL Server 7

Thank you

 
Kevin Frever

Delphi Developer
Sat, 23 Apr 2005 21:08:47 GMT

Re:To sum a TDBGrid Colum programmaticaly while editing in a TDBGrid


Fonkou,

   Check out TClientDataSet's Aggregate fields.

Good luck,
krf

Quote
"FONKOU Barthlmy" <sce....@camnet.cm> wrote in message

news:3dc7a3ee@newsgroups.borland.com...
Quote
> Is there a way to calculate the sum of a numeric column for a TDBGrid
while
> editing this DBGrid ? I want that if the user change the values of one row
> of this column, the the values of the total sum of this column changes
also

> I use Delphi 5 and SQL Server 7

> Thank you

Fur Kennel

Delphi Developer
Sat, 23 Apr 2005 22:00:32 GMT

Re:To sum a TDBGrid Colum programmaticaly while editing in a TDBGrid


Quote
"FONKOU Barthlmy" <sce....@camnet.cm> wrote in message

news:3dc7a3ee@newsgroups.borland.com...

Quote
> Is there a way to calculate the sum of a numeric column for a TDBGrid
while
> editing this DBGrid ? I want that if the user change the values of one row
> of this column, the the values of the total sum of this column changes
also

> I use Delphi 5 and SQL Server 7

If you try infopower components their TwwDBGrid will allow a footer column
and an asociated calculation event.

FK

FONKOU Barthélém

Delphi Developer
Tue, 26 Apr 2005 17:02:34 GMT

Re:To sum a TDBGrid Colum programmaticaly while editing in a TDBGrid


Thanks Kevin

"Kevin Frevert" <kfrevert@workdrinkingcoffeedotcom> a crit dans le message
de news: 3dc7c2d__BEGIN_MASK_n#9g02mG7!__...__END_MASK_i?a63jfAD$z__@newsgroups.borland.com...

Quote
> Fonkou,

>    Check out TClientDataSet's Aggregate fields.

> Good luck,
> krf

> "FONKOU Barthlmy" <sce....@camnet.cm> wrote in message
> news:3dc7a3ee@newsgroups.borland.com...
> > Is there a way to calculate the sum of a numeric column for a TDBGrid
> while
> > editing this DBGrid ? I want that if the user change the values of one
row
> > of this column, the the values of the total sum of this column changes
> also

> > I use Delphi 5 and SQL Server 7

> > Thank you

Other Threads

1. D3.01 How can I format a colum in TDBGrid

2. D3.01 Can I format a TDateTime colum in TDBGrid

3. TextField to TDBGrid field row Colum, Delphi

4. Running sums in TDBGrids

5. Running Sums using TDBGrid

6. Sum values TDBGrid

7. Sum in TDBGrid

8. How to handle edits in TDBGrid ?

9. Editing in a TDBGrid

10. Can't edit TDBGrid