Kbase P116645: Error (7331) using REPOSITION to ROWID statement.
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/11/2007 |
|
Status: Unverified
SYMPTOM(s):
Error (7331) using REPOSITION to ROWID statement.
Cannot reposition query <name> to recid/rowid(s) given. (7331)
Query is a JOIN between two tables, a parent table and a child table.
The REPOSITION statement uses the child rowid only. For example:
REPOSITION browse-1 TO ROWID rChild.
CAUSE:
The correct syntax requires the REPOSTION statement to use the ROWID from the top level down. That is at least the PARENT rowid optionally followed by child ROWIDs in the order of appearance in the query.
FIX:
Use the proper syntax. For example, assuming the query is a JOIN between Customer, Order,OrderLine and Item then any of the following variations would be acceptable:
REPOSITION queryName TO ROWID rCustomer.
REPOSITION queryName TO ROWID rCustomer, rOrder.
REPOSITION queryName TO ROWID rCustomer, rOrder, rOrderLine.
REPOSITION queryName TO ROWID rCustomer, rOrder, rOrderLine, rItem.