Kbase P25000: How to concatenate several address fields together in a Smar
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/12/2003 |
|
Status: Unverified
GOAL:
How to concatenate several address fields together in a SmartDataViewer object?
FIX:
1- Create a calculated field with an expression similar to the following in the SmartDataObject that has a data relationship with the SmartDataViewer object:
(RowObject.Address +
(IF RowObject.Address2 <> "" THEN CHR(13) ELSE "") +
RowObject.Address2 +
(IF RowObject.Address3 <> "" THEN CHR(13) ELSE "") +
RowObject.Address3 + CHR(13) +
RowObject.City + ", " + RowObject.State + ". " + RowObject.Country)
2- Place an editor widget on the SmartDataViewer's frame and associate it with the created calculated field.