Kbase P93577: Temp-table is used as record source instead of the DB table when they have the same name
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
02/11/2004 |
|
Status: Unverified
SYMPTOM(s):
Temp-table is used as record source instead of the DB table
Temp-table and DB table have the same name
Statements like "FOR EACH customer" queries the 'customer' Temp-table even if sports is connected
CAUSE:
This is expected behavior: 4GL pick up the temp table as source if one with the specified name exists.
FIX:
If you want to query specifically the Database table use a DB prefix: FOR EACH sports.customer