Consultor Eletrônico



Kbase P70453: Error 72 when using ALIAS
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   04/03/2004
Status: Unverified

SYMPTOM(s):

Error 72 when using ALIAS

Using the following code to reproduce the issue:

FIND FIRST customer.
IF AVAILABLE test1.customer THEN
MESSAGE customer.cust-num VIEW-AS ALERT-BOX.

(before running the above code create a alias in a separated procedure using the code like:
CREATE ALIAS test1 FOR DATABASE sports.)

** cust-num is ambiguous with Customer.Cust-Num and Customer.Cust-Num (72)

** <field> is ambiguous with <table>.<field> and <table>.<field> (72)

CAUSE:

Cannot mix and match the use of alias in the code otherwise the compiler does not know resolve it.

FIX:

If you have an alias either never refer to the database name, or always refer to it.