Solved

Adding Total fields to a database

Posted on 2001-09-04
1
133 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 50 total points
Comment Utility
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

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Introduction I have seen many questions in this Delphi topic area where queries in threads are needed or suggested. I know bumped into a similar need. This article will address some of the concepts when dealing with a multithreaded delphi database…
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 this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

744 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

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now