Kbase P11166: Only one user can run Query/Results
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  10/28/2008 |
|
Status: Verified
SYMPTOM(s):
Only one user can run Query/Results
FACT(s) (Environment):
Progress 9.x
OpenEdge 10.x
Windows
FIX:
RESULTS documentation states that the .qc and .ql files can reside in a directory other than that of the .db by adding the new directory to the PROPATH search list. However, RESULTS currently does not use the PROPATH list to locate these files.
If different users need different .qc and .ql files, the files can be moved to the working directory for the user's RESULTS session (i.e., where they are when they invoke RESULTS, or where their script "puts" them to run RESULTS).
Example: /users/aname is the working directory for user "aname". The database resides in /usr/dlc/mydb. The user can move the .qc and .ql files from /usr/dlc/mydb to /users/aname and start RESULTS from that directory (/users/aname).
If multiple users access the same .qc, a script or .com file could be used to temporarily copy the .qc and .ql into the working directory and remove them at the end of the RESULTS session.