In the query object's ColumnAttributes, add the following entry for your
boolean fields:

somebooleanfield=BOOLEAN=1,0

This tells IBO to treat the field "somebooleanfield" as boolean, with 1 as
true and 0 as false. Add one line per field in the columnattributes. Note
that this is also available neatly by double-clicking the query object on
you form.


Antti Kurenniemi

----- Original Message -----
From: "Lutz Kutscher" <yahoomail@...>
To: <IBObjects@yahoogroups.com>
Sent: Monday, February 27, 2006 8:30 PM
Subject: [IBO] Boolean params in TIBOQuery


> I'm a newbie to IBObjects, trying to convert an old BDE-Application to
> Firebird/IBO.
> Many of my old queries use a boolean parameter.
> I've spent the past few hours trying to figure out, why the didn't give
> the
> expected results, when I set the parameter to .AsBoolean=True.
> In my FB-Database I use SmallInt fields for boolean fields with 0 = False
> and 1 = True.
> Now I found out, that IBO sets the AsBoolan=True to -1.
> IBO is so flexible, there must be a fairly easy way to tell it to set
> boolean=True to +1 instead, I just can't figure out how.
>
> Thanks for any help,
>
> Lutz
>
>
>
>
> ___________________________________________________________________________
> 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
>
>
>
>
>
>
>