[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [cobalt-developers] OT ? Interbase - how to have auto email when db date value is current date

Hi,
As far as I know this is not possible from the database itself. Putting business logic into the data-tier isn't a good strategy. You better run a program in which this logic is and let the program send the email. If you ever want to switch to another database you don't have to rewrite our businesslogic. 

Johan

Todd Kirk wrote:


Hi all,

In case that didn't fit into the subject line -

We run Interbase from the factory install of our RAQ4R - any got some
tips on how to automatically send an email when a database date value is
the current date.

For example employee data is entered into a table, one of those fields
is a medical examination. Simply it is a date when the employee is due
for another medical examination. 
When the medical expiry date value equals the current date, I would like
an email to go to the office manager stating this person is now due for
an examination.

Thanks in advance for any replies.


kind regards,

Todd Kirk

_______________________________________________
cobalt-developers mailing list
cobalt-developers@xxxxxxxxxxxxxxx
http://list.cobalt.com/mailman/listinfo/cobalt-developers





--
Nilling Software Design
Postbus 43
2280 AA  Rijswijk ZH
w: http://www.nilling.nl