Kbase P134596: 4GL/ABL: How to programmatically determine if you need to apply the 10.1C01 hot fix related to TRIGG
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/09/2009 |
|
Status: Verified
GOAL:
4GL/ABL: How to programmatically determine if you need to apply the 10.1C01 hot fix related to TRIGGER PROCEDURE FOR ASSIGN statements containing the NEW or the NEW VALUE option?
GOAL:
How to programmatically determine if any of your database field ASSIGN triggers uses the NEW or the NEW VALUE option in its TRIGGER PROCEDURE statement?
GOAL:
How to programmatically determine whether any of your database field ASSIGN triggers uses the NEW option in its TRIGGER PROCEDURE statement?
FACT(s) (Environment):
All Supported Operating Systems
OpenEdge 10.1C01 Service Pack
FIX:
If you applied the OpenEdge 10.1C01 Service Pack and any of your database TRIGGER PROCEDURE FOR ASSIGN statements contains the NEW or the NEW VALUE option, then you will need to apply the 10.1C01 hot fix. The following steps will programmatically determine whether any of your database field ASSIGN triggers uses the NEW or the NEW VALUE option in its TRIGGER PROCEDURE statement:
1. Create the text file cDirListFileName.txt in your OpenEdge 4GL/ABL session working directory containing the absolute path names of each directory that contains database triggers putting each directory on a separate line in the file.
2. Save a copy of the 4GL/ABL procedure ListAllAssignTriggersUsingTheNewOption.p from the note below in your OpenEdge 4GL/ABL session working directory.
3. Run the 4GL/ABL procedure ListAllAssignTriggersUsingTheNewOption.p.
4. Examine the file AssignTriggersReport.txt generated by running the procedure ListAllAssignTriggersUsingTheNewOption.p.
5. If the file is empty, then none of your database field ASSIGN triggers is using the NEW or the NEW VALUE option and you do NOT need to apply the hot fix.
6. If the file is not empty, then the database field ASSIGN triggers listed in the report are using the NEW or the NEW VALUE option and you NEED to apply the hot fix.