Subject | Boolean params in TIBOQuery |
---|---|
Author | Lutz Kutscher |
Post date | 2006-02-27T18:30:44Z |
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
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