This is right i use an IBO emulation of Boolean field but, if i have
understand, this emulation don't work on Filter property.
It's right ?
I haven't any other way ?

Regards,
Enrico Raviglione.


-----Messaggio originale-----
Da: Artur Anjos [mailto:arsoft@...]
Inviato: lunedi 18 febbraio 2002 18.04
A: IBObjects@yahoogroups.com
Oggetto: Re: [IBO] Error filtering TIBO* on boolean Fields


I think you must change that Field from Boolean to Char again, or change the
visual component (if you have the sources). There is no Boolean Fields in
IB, and what you are using it's an IBO feature that emulates Booelan Fields
at the client side.

So, don't set the Field to be Boolean will be the most simple way.

Artur

----- Original Message -----
From: Enrico Raviglione
To: 'IBObjects@yahoogroups.com'
Sent: Monday, February 18, 2002 5:10 PM
Subject: R: [IBO] Error filtering TIBO* on boolean Fields


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)




[Non-text portions of this message have been removed]



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