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 [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
-- Nilling Software Design Postbus 43 2280 AA Rijswijk ZH w: http://www.nilling.nl
_______________________________________________ cobalt-developers mailing list [EMAIL PROTECTED] http://list.cobalt.com/mailman/listinfo/cobalt-developers
