Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Adding Total fields to a database

Posted on 2001-09-04
1
Medium Priority
?
145 Views
Last Modified: 2010-04-06
I may be being totally stupid but having worked in Paradox for a number of years, I was able to add to a form a summary field for numberic fields.  I cannot find a component to do this in Delphi.(or am I missing something) I have been able to achive the same result with code, but thought  there may be an easier way.

I have not been using delphi for very long and would appreciate aome help.
0
Comment
Question by:BillHorsley
1 Comment
 
LVL 2

Accepted Solution

by:
Felixin earned 150 total points
ID: 6452927
There is no component in Delphi, that I know, to do that.

You can make a Query with a SUM

SELECT
  SUM (MyField) as Total
FROM
  MYTable
0

Featured Post

[Webinar] Database Backup and Recovery

Does your company store data on premises, off site, in the cloud, or a combination of these? If you answered “yes”, you need a data backup recovery plan that fits each and every platform. Watch now as as Percona teaches us how to build agile data backup recovery plan.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Hello everybody This Article will show you how to validate number with TEdit control, What's the TEdit control? TEdit is a standard Windows edit control on a form, it allows to user to write, read and copy/paste single line of text. Usua…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
In a question here at Experts Exchange (https://www.experts-exchange.com/questions/29062564/Adobe-acrobat-reader-DC.html), a member asked how to create a signature in Adobe Acrobat Reader DC (the free Reader product, not the paid, full Acrobat produ…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…
Suggested Courses
Course of the Month13 days, 1 hour left to enroll

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question