Kbase P110291: How to link 2 tables using fields with different data-types in CorVu?
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
27/10/2005 |
|
Status: Unverified
GOAL:
How to link 2 tables using fields with different data-types in CorVu?
GOAL:
How to link 2 fields with different data-types in CorVu?
GOAL:
How to avoid error "Incompatible data types in expression or assignment (223)" when linking fields with different data-types in CorVu?
GOAL:
How to link an integer and a character field in CorVu, avoiding error "Incompatible data types in expression or assignment (223)"?
FACT(s) (Environment):
CorVu
FIX:
Add a Virtual column to the table in the Knowledge library which converts the column type, so that the conversion is made in the SQL.
For example, to link an integer and a character field:
Add a virtual column called strA1Num with a 3 part formula:
STRING( constant
A1num column
) constant
Then use this virtual column for the join to the A2char column in table B.
This should generate the following SQL when you preview the SQL in Graphical Analysis:
SELECT
A1num,
A2char
FROM
sports.A2 b,
sports.A1 a
WHERE
STRING(a.A1num) = b.A2char