Re: automatic calculation on each record on column

From	Bernard Peek <bap@shrdlu.com>
Newsgroups	comp.lang.pascal.delphi.databases
Subject	Re: automatic calculation on each record on column
Date	2014-01-14 17:52 +0000
Organization	none
Message-ID	<bjlbptFo2v6U1@mid.individual.net> (permalink)
References	<c48e1eeb-532d-43c8-8e1f-b55acad74c15@googlegroups.com>

Show all headers | View raw

On 10/01/14 02:37, Thomas Colvin wrote:
> 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.
>
> How do I do that?

This is something that many databases can handle for themselves. You 
could define a new virtual column calculated from the birth data and the 
current date or you could use SQL.



-- 
Bernard Peek
bap@shrdlu.com

Back to comp.lang.pascal.delphi.databases | Previous | Next — Previous 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