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'

Regards,
Enrico Raviglione.


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


At 18/02/2002 12:38 PM, you wrote:

>Hi,
>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. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)



___________________________________________________________________________
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 !

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/