[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 255
  • Last Modified:

calculated field

How can I get the sum of a calculated field ?

Andrew
0
andrewyu
Asked:
andrewyu
1 Solution
 
viktornetCommented:
What calculated field?? you mean in a database??please give further explanatin...

-Viktor
0
 
venksCommented:
As far as i know there is no function in delphi to get the sum automatically.
Yoy can use SQL with a query component or use quickreport expressions to get the sum of any numeric field
venks
0
 
andrewyuAuthor Commented:
That's ok !

Thank you very much !

Andrew
0
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
andrewyuAuthor Commented:
Adjusted points to 10
0
 
skatan187Commented:
I have a component
TMathParser1 :


Expression Evaluator v1.0 for Delphi                                         http://www.bitsoft.com                                          info@bitsoft.com                                                 { This file is distributed as freeware and without warranties of any kind. }
{ You can use it in your own applications at your own risk.                }
{ See the License Agreement for more information.                          }


0
 
skatan187Commented:
I am not sure if that's what you ment?
0
 
andrewyuAuthor Commented:
Let say, I do "select sum(area * population) from country" in TQuery !
But, if I have a calculated field, called AP, in TTable now and I want to get the sum of this calculated field ?
So, I hope to know how can I get this value !

Andrew
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now