Consultor Eletrônico



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.