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:

SELECT ALL UTENTI.*
FROM UTENTI
WHERE (UPPER( UTENTI.PERSGIU ) = UPPER( True ))
ORDER BY UTENTI.KEYUTENTE ASC

And the server return this Error:

ERRCODE = 335544569
----*/
/*---
PREPARE STATEMENT
TR_HANDLE = 15948112
STMT_HANDLE = 15948184

SELECT ALL UTENTI.*
FROM UTENTI
WHERE (UPPER( UTENTI.PERSGIU ) = UPPER( True ))
ORDER BY UTENTI.KEYUTENTE ASC

FIELDS = [ Version 1 SQLd 2 SQLn 30
RDB$RELATION_FIELDS.RDB$FIELD_NAME = <NIL>
RDB$RELATION_FIELDS.RDB$RELATION_NAME = <NIL> ]

ERRCODE = 335544569
----*/
/*---
INTERPRETE BUFFER =

ERRCODE = 17
----*/
/*---
INTERPRETE BUFFER = Dynamic SQL Error

ERRCODE = 21
----*/
/*---
INTERPRETE BUFFER = SQL error code = -206

ERRCODE = 14
----*/
/*---
INTERPRETE BUFFER = Column unknown

ERRCODE = 4
----*/
/*---
INTERPRETE BUFFER = TRUE

ERRCODE = -1
----*/

I know that i can do the filter in different manner (like SQLWhereItem) but
i need to use the VCL Compatible filter syntax and the Filter property (i
use a visual component for make my filters).

Regards,
Enrico Raviglione.




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