Kbase P114955: How to trigger database events asynchronously?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
How to trigger database events asynchronously?
GOAL:
How to know when the date in a record field is approaching?
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
FIX:
There is currently no facility in Progress nor OpenEdge to trigger a database even when a specific condition happens and this condition happens outside of regular database input or output operations. (When the condition happens during database operations, it is possible to use database triggers to detect the condition.)
The workaround for this is to run periodically a procedure which searches through all relevant records for the condition. Setting up appropriate indexes for this search is recommended for large table sizes.