Kbase P16879: Query/Results, MFG PRO, and error (201)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/25/2003 |
|
Status: Unverified
SYMPTOM(s):
MFG PRO
PROGRESS error messages when compiling a RESULTS query form :-
"** Unknown Field or Variable name global_userid. (201)"
"** <program>\gppswd.v Could not understand line <number>. (196)"
CAUSE:
This is caused due a database trigger looking for the value of the Global_userID variable. This Variable is only available in an MFG Pro session.
FIX:
By changing the way by which we invoke Results we can overcome this issue. In the manner by which we invoke Results we run Results.p.
To resolve this create a new .p to invoke these variables and set their values to the appropriate user ID. These should be set via user input and not hard coded for security purposes. Then this .p should then RUN RESULTS.p to invoke your results session.