Kbase P7193: Erros (545) and (855) when compiling a procedure that connects to a Database and also refers to the
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/29/2005 |
|
Status: Verified
SYMPTOM(s):
Getting errors (545) and (855) when compiling a procedure that connects to a Database and also refers to the Database in its code
Unknown or ambiguous table <table>. (545)
Unknown database name <db name>. (855)
CAUSE:
The Database is being referenced in the same program that establishes a connection to it, which is incorrect. The Database must be connected in a separate program, which should be executed BEFORE running a procedure that contains references to the Database
FIX:
To connect the Database using the 4GL, the code needs to be split into 2 procedures, proc1.p and proc2.p:
Proc1.p has 2 lines: connect <dbname> and run "proc2.p".
Proc2.p contains the main body of code.