Kbase P102459: Can you use Progress database triggers with a DataServer?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/23/2010 |
|
Status: Verified
GOAL:
Can you use Progress database triggers with a DataServer?
GOAL:
Is it possible to use Progress database triggers against a foreign database?
GOAL:
Is it possible to use Progress database triggers against a 3rd party database?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
DataServers
FIX:
If the database is one that we support through the Progress DataServers then yes you can.
They work the same way as when using a Progress database, the triggers reside on the client side and are defined through the Data Dictionary for the schema holder. The 4GL can still cause the defined trigger to fire on the programmed event.
You do however need to make sure the code within the triggers conform with any special coding requirements as per the appropriate Progress DataServer guide. Also within the Programming Considerations chapter of the DataServer Guide there is a section Database Triggers that explains the behavior of both Progress and non-Progress triggers.