Subject Re: [IBO] Calculated fields problem..
Author Svein Erling Tysvær
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.

HTH,
Set

--- In IBObjects@yahoogroups.com, Woody wrote:
> I will continue to try any other suggestions if there are any more ideas.