Kbase P49464: Record Reads on: FIND table WHERE ROWID(table)=<value>
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
16/10/2008 |
|
Status: Unverified
GOAL:
Why "FIND table WHERE ROWID(table)=<value>" is not just one Record Read?
GOAL:
Record Reads on: FIND table WHERE ROWID(table)=<value>
FIX:
The statement
FIND <table> WHERE ROWID(<table>)=<value>
is not just one Record Read, even if there is only one additional Record Read due to that statement in the following program.
DEF VAR xx AS ROWID.
FIND FIRST customer.
xx = ROWID(customer).
FIND customer WHERE ROWID(customer) = xx.
There is exactly the same number of Record Reads when running any of the two statements below within a new, separate, session.
1. FIND FIRST customer.
2. FIND customer WHERE ROWID(customer) = TO-ROWID("0x00000067").
Having run the following program gave the ROWID value used above.
DEF VAR XX AS ROWID.
FIND FIRST CUSTOMER.
XX= ROWID(CUSTOMER).
DISPLAY STRING(XX) FORMAT "X(32)".