Kbase P83365: CAN-FIND fails using WHERE clause comparing ROWID IS NOT NULL on 9.1C
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
9/2/2004 |
|
Status: Unverified
FACT(s) (Environment):
Oracle DataServer
FACT(s) (Environment):
Progress 9.1C
SYMPTOM(s):
CAN-FIND fails
Using WHERE clause comparing ROWID IS NOT NULL
Using SQL*NET
Can-find fails returning false results
CAUSE:
Bug# 20040608-060
CAUSE:
Missing alias for table name reference in PROGRESS_RECID column resulting of a invalid column name error cause the CAN_FIND.
Note that if a CAN-FIND fail due a syntax error it still return FALSE but does not return error resulting on an unexpected results.
FIX:
Upgrade to 9.1D. If upgrade to 9.1D is not possible you can get around of this problem using Remote DataServer Broker configuration on 9.1C