• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 156
  • Last Modified:

sum up some tablefields and build chart

hi, im a learner of delphi at the moment and wrote a small application. in this app. i have a table with numeric values. what im trying to do now is sum up a few of this values and automatically build a chart with these sums and then store the chart under a certain name. i tried several queries with sum but none worked. i hope u can help me find a solution, thx
0
ugross
Asked:
ugross
  • 2
  • 2
1 Solution
 
rwilson032697Commented:
You can sum a field in a table like this:

select sum(Afield) as FieldSum from ATable where ATable.AnotherField = 42

Cheers,

Raymond.
0
 
ugrossAuthor Commented:
hi, sounds pretty simple and ok will try it, do u have any idea how to put these value straight into a chart. cheers

0
 
rwilson032697Commented:
You can so this using a TChart (in the additional tab).

Add one of these to a form, create an appropriate series and use code somethting like this to fill it in:

(This is a snip from my Mortgage Planning app where it creates a chart of interest and principal payments over time)

  for I := 0 to CurrentScenario.Payments.Count - 1 do
    begin
      TotalScenarioInterest := TotalScenarioInterest + CurrentScenario.payments[i].InterestPortion;

      ScenarioPrincipalSeries.AddXY(CurrentScenario.Payments[i].PaymentDate,
                                    CurrentScenario.Payments[i].PrincipalRemaining, '', clTeeColor);
      ScenarioInterestSeries.AddXY(CurrentScenario.Payments[i].PaymentDate,
                                   TotalScenarioInterest, '', clTeeColor);
    end;

Cheers,

Raymond.
0
 
ugrossAuthor Commented:
thanks for this profund answers rymond, will try them, thou i think there must be something more simple. cheers and thx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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