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
>
>
>
> ___________________________________________________________________________
> IB Objects - direct, complete, custom connectivity to Firebird or
> InterBase
> without the need for BDE, ODBC or any other layer.
> ___________________________________________________________________________
> http://www.ibobjects.com - your IBO community resource for Tech Info
> papers,
> keyword-searchable FAQ, community code contributions and more !
> Yahoo! Groups Links
>
>
>
>
>
>
>