Kbase P1167: CorVu: Making a Virtual Column Picklist Key from 2 Columns
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  11/12/2002 |
|
Status: Unverified
FACT(s) (Environment):
CorVu
SYMPTOM(s):
Creating a virtual column picklist key from 2 columns in the knowledge library
A truncated string is returned
Cannot change the field datatypes as a workaround
CAUSE:
The Progress ESQL restriction means that any calculated SQL character fields (for example, custname and custcode) are given the default format of 8 chars. This cannot be overridden. Consequently, you always get a truncated string returned.
FIX:
CorVu has an ABAServer version of the Progress gateway that has a patch for this issue.