Kbase P35424: Trigger fail with errors 425 and 725
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/08/2003 |
|
Status: Unverified
SYMPTOM(s):
Trigger fail with errors 425 and 725
Table <table> is in database <db name> and <db name> (425)
Unknown or ambiguous table <table>. (725)
Using same trigger for same tables in more than one database
CAUSE:
Triggers procedures should be exclusives to only one database.
You need to have a set of source code for the database schema triggers and one set of r-code for each database that uses those triggers.
FIX:
Create separate r-code for each database that will need the schema triggers.
Use -trig parameter used for each database to point to the appropriate trigger code that has been compiled for that database.