Kbase 15922: How to replace ? when using a left outer join with a browse
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
10/05/1998 |
|
How to replace ? when using a left outer join with a browse
When using a left outer join, any fields that display for the
second table in which a record was not found show a ?.
To display something other than the ? you may use a calculated
field. For example, consider a query for a browse which is
for each customer, each salesrep of customer outer-join which
displays customer number, customer name, customer salesrep, and
salesrep name. Salesrep name comes from the salesrep table and
can be displayed with the following in a calculated field:
if avail salesrep then salesrep.rep-name
else 'No salesrep' @ salesrep.rep-name
to display 'No salesrep' in the salesrep name column instead of
a ?.
Progress Software Technical Support Note # 15922