RDOHELP72.HLB  —  Value expr, concatenated_expression, Examples
    Example 1

    Use a concatenated expression as a field in a view:

    DEFINE VIEW MAIL OF
     E IN EMPLOYEES.
      NAME COMPUTED BY
        E.FIRST_NAME | ' ' | E.MIDDLE_INITIAL | ' ' | E.LAST_NAME.
      E.ADDRESS_DATA_1.
      E.CITY.
      E.POSTAL_CODE.
    END MAIL VIEW.

    This statement creates a field for the view by combining the
    three name fields from the EMPLOYEES relation.

    Example 2

    Use a concatenated expression to simulate an edit string:

    DEFINE VIEW BUCKS OF S IN SALARY_HISTORY.
       EMPLOYEE_ID.
       SALARY_START.
       SALARY_END.
       SAL COMPUTED BY "$"|S.SALARY_AMOUNT.
    END.

    When you display the fields of BUCKS, a dollar sign appears in
    front of the salary amount.
Close Help