Kbase P21601: "CAN-FIND" statement in a Temp-Table returns "FALSE" even though record exists
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
1/12/2007 |
|
Status: Verified
SYMPTOM(s):
"CAN-FIND" statement in a Temp-Table returns "FALSE" even though record exists
Field used in Primary Index is not explicitly assigned and has the default value.
CAUSE:
This is expected behaviour that is applicable to all tables, not just temp-tables. Index information is not always written out until the record is released. This occurs on occasions, but not always.
This is because Progress waits as long as possible to write records out for optimization.
FIX:
Apply RELEASE or VALIDATE or FIND before CAN-FIND, which will force indexing and writing of the records.