Subject | Re: [IBO] Calculated fields problem.. |
---|---|
Author | Svein Erling Tysvær |
Post date | 2004-10-21T10:04:54Z |
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
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.