• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

A little OT

D

DanC

Diamond Member
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.
 
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.
 
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. 🙂
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top