Path: csiph.com!v102.xanadu-bbs.net!xanadu-bbs.net!feeder.erje.net!eu.feeder.erje.net!news.swapon.de!fu-berlin.de!uni-berlin.de!individual.net!not-for-mail From: Bernard Peek Newsgroups: comp.lang.pascal.delphi.databases Subject: Re: automatic calculation on each record on column Date: Tue, 14 Jan 2014 17:52:00 +0000 Organization: none Lines: 18 Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: individual.net EVx05zS73PN30LGjoljIewnoimFrN4P7qrqzhm0nG+DkuKM1mA Cancel-Lock: sha1:AjAUtH6BzJw8DGVf4EthEAap4yc= User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:24.0) Gecko/20100101 Thunderbird/24.2.0 In-Reply-To: Xref: csiph.com comp.lang.pascal.delphi.databases:21 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