Kbase P73693: Joining two tables in the Report Builder fails with error 46
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
04/02/2010 |
|
Status: Unverified
SYMPTOM(s):
Joining two tables in the Report Builder fails with error 46
** Use INTEGER function to compare integer index-field and decimal (46)
The error 46 is displayed when the join is attempted between two tables where
one field in join is integer data type (also part of an index) and the field
in another table of decimal data type
FACT(s) (Environment):
Progress 8.x
Progress 9.x
CAUSE:
Bug# OE00053015
FIX:
Replicate the table having the decimal field used in join to another
table where the corresponding field is of the integer data type and
then use that table in the Report Builder join.