Groups | Search | Server Info | Login | Register

Groups > comp.lang.pascal.delphi.databases > #20

Re: automatic calculation on each record on column

Show all headers | View raw

In comp.lang.pascal.delphi.databases message <c48e1eeb-532d-43c8-8e1f-
b55acad74c15@googlegroups.com>, Thu, 9 Jan 2014 18:37:56, Thomas Colvin
<colvinsoutpost@gmail.com> posted:

>Have a table and everything is working fine.
>
>One column has heading of Date of Birth. The next column heading is Age.
>
>What I would like to happen is when little program running and I type
>in the date of birth then program automatically calculates and installs
>the age in the adjoining column record out to two decimals.

Because years are not all the same length, you will have to think quite
carefully about what you mean by that, especially if your answer is to
be compared with someone else's.

The average length of a Gregorian calendar year is 365.2425 days.  But
the average length of a Gregorian year during the lifetimes of those now
alive is very nearly 365.25 days.

Note <http://en.wikipedia.org/wiki/Oldest_person>.

-- 
 (c) John Stockton, nr London, UK.   E-mail, see Home Page.    Turnpike v6.05.
 Website  <http://www.merlyn.demon.co.uk/> - w. FAQish topics, links, acronyms
 PAS EXE etc. : <http://www.merlyn.demon.co.uk/programs/> - see in 00index.htm
 Dates - miscdate.htm estrdate.htm js-dates.htm pas-time.htm critdate.htm etc.

Back to comp.lang.pascal.delphi.databases | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

automatic calculation on each record on column Thomas Colvin <colvinsoutpost@gmail.com> - 2014-01-09 18:37 -0800
  Re: automatic calculation on each record on column Dr J R Stockton <reply1400@merlyn.demon.co.uk.invalid> - 2014-01-11 20:46 +0000
  Re: automatic calculation on each record on column Bernard Peek <bap@shrdlu.com> - 2014-01-14 17:52 +0000

csiph-web