Subject | Re: [IBO] Formatting text in a ComboBox (or grid column) |
---|---|
Author | Dennis McFall |
Post date | 2005-07-01T20:52:53Z |
Antti Kurenniemi wrote:
SELECT ..... T1.LASTNAME || ', ' || T1.FIRSTNAME FULLNAME ..... FROM
TABLEONE T1 .....
Then use the computed field name "Fullname" for the various
FieldDisplayLable values etc.
Dennis McFall
>Hello again.The SQL property of the TIB_Query component:
>
>
>I have a table with people's names in it, split to firstname and lastname
>fields. How would I go about having the name formatted from the two separate
>fields to one, as "Kurenniemi, Antti" (that's "lastname, firstname") in a
>IB_LookupCombo - or for that matter, in a grid column?
>
>
>
>
SELECT ..... T1.LASTNAME || ', ' || T1.FIRSTNAME FULLNAME ..... FROM
TABLEONE T1 .....
Then use the computed field name "Fullname" for the various
FieldDisplayLable values etc.
Dennis McFall