> Why not simply let Firebird/InterBase do the work rather than IBO?
>
> SELECT ID
> , EMPNUM
> , FIRSTNAME
> , LASTNAME
> , FIRSTNAME || ' ' || LASTNAME AS FULLNAME
> , MI
> , STREET1
> , STREET2
> , CITY
> , STATE
> , ZIPCODE
> , HOMEPHONE
> , HIREDATE
> , TERMINATIONDATE
> , COMMENT
> FROM EMPLOYEE
> ORDER BY LASTNAME, FIRSTNAME, MI
>
> possibly with COALESCE if you're using Fb 1.5 and have nulls.

Because it doesn't update the calculated field when one of the fields are
changed, that's why. It has to be calculated again and doing it this way
won't do that.

Woody