Subject R: [IBO] Error filtering TIBO* on boolean Fields
Author Enrico Raviglione
Hi Daniel,
this work fine.
But i have a visual component (very user friendly) on my form who write the
filter property form me (and for my client) and this component don't like an
expression of this type:

BooleanField = 'character'

Enrico Raviglione.

-----Messaggio originale-----
Da: Daniel Rail [mailto:drail@...]
Inviato: lunedi 18 febbraio 2002 17.32
Oggetto: Re: [IBO] Error filtering TIBO* on boolean Fields

At 18/02/2002 12:38 PM, you wrote:
>i try to do a filter a TIBOTable/Query on Boolean Fields.
>In my Table UTENTI i have the Boolean Field PERSGIU, on Interbase i have
>defined it as D_BOOLEAN --> CHAR(1)
>In TIB_Connection i have set ColumnAttributes with D_BOOLEAN=BOOLEAN=T,F
>then in FieldEditor i see my Field as TBooleanField.
>When i set the TIBOTable Filter property with "PERSGIU = True" the SQL
>sended to the server are:

Write your filter the same way as it would be written in a WHERE
clause. This is how it is designed.

In other words, set the TIBOTable.Filter with " PERSGIU='T' ".

Daniel Rail
Senior System Engineer
ACCRA Group Inc. (
ACCRA Med Software Inc. (

IB Objects - direct, complete, custom connectivity to Firebird or InterBase
without the need for BDE, ODBC or any other layer.
___________________________________________________________________________ - your IBO community resource for Tech Info papers,
keyword-searchable FAQ, community code contributions and more !

Your use of Yahoo! Groups is subject to