Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.lang.pascal.delphi.databases > #21
| 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 <bap@shrdlu.com> |
| 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 | <bjlbptFo2v6U1@mid.individual.net> (permalink) |
| References | <c48e1eeb-532d-43c8-8e1f-b55acad74c15@googlegroups.com> |
| 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 | <c48e1eeb-532d-43c8-8e1f-b55acad74c15@googlegroups.com> |
| Xref | csiph.com comp.lang.pascal.delphi.databases:21 |
Show key headers only | 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
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