Calculating the Records

Question:
Can you help me to get a calculated value from many records? A dataset(Paradox table) that I use has an Integer field which is used to put minutes value. How do I add up the value of these fields on many records? In other words, I want to calculate same fields for multiple records in one dataset. I am using DBGrid, and this dataset is a detail table for a master.Thank you.Stan

Answer:
There are two ways to do this:1) You can drop a TQuery on your form and set it up to run at runtime to sum that field like so:

SELECT Sum(IntField) as IntFieldSumFROM "MyTable.DB"

Then in the OnCalcFields method for the DBGrid, you can just set the value to

Query1.FieldByName('IntFieldSum).AsInteger;

2) The other way is to scan through the table and do an incremental add.Notice that I didn’t put the query in the OnCalcFields method. This is because it would execute everytime you entered a record or made a change – not good. The second method is NOT recommended, especially if you have a lot of records in the table.

Share the Post:
Share on facebook
Share on twitter
Share on linkedin

Overview

The Latest

microsoft careers

Top Careers at Microsoft

Microsoft has gained its position as one of the top companies in the world, and Microsoft careers are flourishing. This multinational company is efficiently developing popular software and computers with other consumer electronics. It is a dream come true for so many people to acquire a high paid, high-prestige job

your company's audio

4 Areas of Your Company Where Your Audio Really Matters

Your company probably relies on audio more than you realize. Whether you’re creating a spoken text message to a colleague or giving a speech, you want your audio to shine. Otherwise, you could cause avoidable friction points and potentially hurt your brand reputation. For example, let’s say you create a

chrome os developer mode

How to Turn on Chrome OS Developer Mode

Google’s Chrome OS is a popular operating system that is widely used on Chromebooks and other devices. While it is designed to be simple and user-friendly, there are times when users may want to access additional features and functionality. One way to do this is by turning on Chrome OS