Solved

calculated field

Posted on 2007-04-10
4
317 Views
Last Modified: 2010-04-06
got 1 field in adotable called 'working_days' (integer)
inserted into a table calculated field called 'hours' (integer)
how do I make adotable calculate:  'hours'='working_days' / 8

0
Comment
Question by:Vrtnar
  • 2
4 Comments
 
LVL 26

Expert Comment

by:EddieShipman
ID: 18882497
In the OnCalcFields event.
0
 
LVL 26

Accepted Solution

by:
EddieShipman earned 50 total points
ID: 18882530
procedure TForm1.ADOTable1CalcFields(DataSet: TDataSet);
begin
  ADOTable1Hours.AsInteger := ADOTable1Working_Days.AsInteger div 8;
end;
0
 
LVL 1

Expert Comment

by:Computer101
ID: 21156545
Forced accept.

Computer101
EE Admin
0

Featured Post

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Show Listview image from database (String field) 5 124
delphi parse string to params 3 122
How to debug For loops? 3 49
Dynamically Created Query 3 55
The uses clause is one of those things that just tends to grow and grow. Most of the time this is in the main form, as it's from this form that all others are called. If you have a big application (including many forms), the uses clause in the in…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

770 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