Its very simple, just one TIBOQuery or TIB_Query used with an select
Upper(Item) where the LookUp listfield = same Item

----- Original Message -----
From: "Jason Wharton" <jwharton@...>
To: <IBObjects@yahoogroups.com>
Sent: Saturday, December 10, 2005 2:16 PM
Subject: RE: [IBO] IB_Components problem


>I would very much appreciate a sample app being produced to demonstrate
>this
> problem.
>
> Thanks,
> Jason Wharton
>
>
>> -----Original Message-----
>> From: IBObjects@yahoogroups.com [mailto:IBObjects@yahoogroups.com]On
>> Behalf Of Hans
>> Sent: Sunday, December 04, 2005 3:42 PM
>> To: IBObjects@yahoogroups.com
>> Subject: [IBO] IB_Components problem
>>
>>
>> [IBO] IB_Components problem
>>
>> Using
>>
>> Select Item_ID, Upper(Item_Name) Item_Name from LookupTable
>>
>> as the ListSource in a DBLookup using Item_Name as the ListField
>>
>> aborts in a SQL error after hitting a few search keys with a
>> rather intering
>> multiple nested Upper(Upper(Upper(Upper ...(Item_Name SQL Query,
>> ending in a Starting With Upper(Item_Name)
>> as part of the horizontal refinement.
>>
>> Best Regards
>> Hans
>
>
>
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
>
>