Thanks for the information. Won't be a problem at this particular case, but
I'm sure eventually I'll run into that as well - much to read about SQL as
well...


Antti Kurenniemi

----- Original Message -----
From: "Hans" <hhoogstraat@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, July 02, 2005 5:09 PM
Subject: Re: [IBO] Formatting text in a ComboBox (or grid column)


> If either FIRSTNAME or LASTNAME is a NULL, FULLNAME will be a NULL
>
> ----- Original Message -----
> From: "Antti Kurenniemi" <Antti@...>
> To: <IBObjects@yahoogroups.com>
> Sent: Saturday, July 02, 2005 4:27 AM
> Subject: Re: [IBO] Formatting text in a ComboBox (or grid column)
>
>
>>> The SQL property of the TIB_Query component:
>>>
>>> SELECT ..... T1.LASTNAME || ', ' || T1.FIRSTNAME FULLNAME ..... FROM
>>> TABLEONE T1 .....
>>> Then use the computed field name "Fullname" for the various
>>> FieldDisplayLable values etc.
>>
>> Thank you Dennis, works like a champ :-)
>>
>>
>> Antti Kurenniemi
>>