Kbase P45996: How to run a script on the server side for certain condition
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/10/2003 |
|
Status: Unverified
GOAL:
How to run a script on the server side for certain conditions in the database
( field changed, record deleted ... etc ) when modification are generated by remote clients.
FIX:
Make clients populate a table ( kind of a queue list ) which will be processed by a Progress background process running on the server side. The "queue" table can be updated by a database trigger or application itself. The background process has to clean up the "queue" table while the information is processed.
This method makes the database OS server react ( for example sending e-mails, running scripts, etc ... ) to certain modifications in the database generated by the remote user sessions.