A little OT

[DanC]

Sure... it should be in software, apps, programming & games - but I don't KNOW anyone over there.

Anyway - Would anyone know a SIMPLE way to do a SUM on a DBGrid column that's displaying a SQL query result?

I'm pulling data from an Advantage Data Server app, for the purpose of automating our commissions system. It's Delphi 3 btw.

 

[BlackMountainCow]

:thumbsup:

 

[Ross Whitehead]

From a friend...

Quick answer is to use third party components like Developer Express. Other option is: TClientDataSet has something called Aggregate field (I don't have D3 to check it there). I don't know any other simple way to do this using only standard TDBGrid.

 

[DanC]

Thanks Ross! I do appreciate the information.

I've looked at a couple of 3rd party data-aware components, but nothing yet
that turns my "crank" so to speak.

I was hoping there'd be some really easy SQL routine that would do the deed.
I'll keep on checking.