Kbase P11584: Use additional field to fetch a particular records in a para
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
18/03/2003 |
|
Status: Unverified
SYMPTOM(s):
The ROWID's of original-temp-table records cannot be used to fetch records in a temp-table defined with the syntax DEFINE INPUT PARAMETER TABLE FOR temp-table-name
CAUSE:
Expected behavior. The original temp-table and the parameter temp-table are two different temp-tables.
FIX:
Rely on a uniqueId integer additional field rather than on the ROWID of the records. An other option is to use an additional field RowIdent as ROWID in both temp-table, which would hold the ROWID of the original-temp-table records in both table => Looks like ADM2 technique. (except that RowIdent is AS CHAR, so it can hold a list of multiple rowids for joined tables)