Kbase P85951: How to suppress the ? character displayed for records with no corresponding entries in a browse with
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
28/06/2004 |
|
Status: Unverified
GOAL:
How to suppress the ? character displayed for records with no corresponding entries in a browse with a LEFT-OUTER-JOIN
GOAL:
Records with no corresponding entries in a LEFT-OUTER-JOIN displays ? character
GOAL:
How to use calculated fields to hide the unknown value (?) when record in a LEFT-OUTER-JOIN has no related children
FIX:
Use a calculated field to suppress the ? character.
Sample calculated field formulas:
For blank entry, a String must be returned:
IF (Order.Ordernum = ?) THEN ("") ELSE STRING(Order.Ordernum) @ cfOrderNum
OR
To maintain the original data-type (INT), returns 0:
IF (Order.Ordernum = ?) THEN 0 ELSE Order.Ordernum @ cfOrderNum