Kbase P111834: CorVu Graphical Analysis fails to display data when the database tables uses a FIND trigger
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
12/14/2005 |
|
Status: Unverified
FACT(s) (Environment):
CorVu 4.3
SYMPTOM(s):
Querying database table using CorVu's Graphical Analysis tool
Graphical Analysis tool does not display any results
FIND trigger has been defined against the database table
If the database trigger is removed then Graphical Analysis tool will display results
Result appears to be dependent upon the code that the trigger is executing:
PAUSE 0 - fails
RETURN - succeeds
CAUSE:
The exact cause is unknown at the time of this writing.
It is expected behaviour that if the table has a READ or SELECT trigger on it, then the CorVu query will activate it. In addition, if the trigger alters the returned data format then CorVu will not be able to display it.
FIX:
Create a dummy trigger procedure for the table, containing the following code:
TRIGGER PROCEDURE FOR FIND OF Customer.
RETURN.
Copy the file into the CorVu installation folder
When the FIND trigger fires, CorVu will find and use the dummy trigger procedure and will therefore display data within Graphical Analysis