Kbase 20888: CorVu: Making a Virtual Column Picklist Key from 2 Columns
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/10/2003 |
|
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
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:
As a workaround use an 8 digit numeric value for custid, and a subsid of 3 digits
(also numeric) to make a numeric key instead of a character key. Progress ESQL can return big decimal numbers. You can either multiply the two numbers and hope this is always unique, or make a concatenated numeric key.
Try this example:
custid = 456345
subsid = 102
You want cskey = 102456345
1) Make a Real Number / Digital cskey = 102.456345
2) In Knowledge library, make a virtual column, type 5 part
formula
( constant
subsid column
+ ( constant
custid column
* 0.00000001)) constant
3) Override the data type of the virtual column to real
number, stored format 11.