Enrico,

After I answer Helen's message I read yours...

My ColumnAttributes are like this, as per your exemple:

ColumnAttributes = PERSGIU=BOOLEAN='T', 'F'

After I take the quotes away it works...

:-)

Many many many thanks to u. I knew it was a simple detail, but I gived
up to find the solution cause I needed to go on with work...

Thanks again,

Andrei



2005/11/4, Enrico Raviglione <e.raviglione@...>:

> Hi,
> sorry but i don't understand what road do you have chosen.
>
> In your TIBOTable, your BOOLEAN fields are coded as TBooleanFields or
> TStringFields ?
>
> When i ported all my applications from BDE/Paradox to FireBird, i have
> keep all my BOOLEAN fields as TBooleanFields in my TIBOTable or
> TIBOQuery, without any problem using it in CheckBox or testing it in my
> code.
>
> Here what i do:
>
> Into my database i create a DOMAIN:
>
> CREATE DOMAIN D_BOOLEAN AS
> CHAR(1)
> DEFAULT 'F'
> CHECK (value in ('F', 'T'))
>
> All BOOLEAN fields in my database tables are declare as TYPE =
> D_BOOLEAN, i add also one Trigger for any table where i set to 'F' the
> value of D_BOOLEAN fields who are passed as NULL, see my example:
>
> CREATE TABLE UTENTI (
> KEYUTENTE D_KEYDB NOT NULL,
> ... some fields ...
>
> PERSGIU D_BOOLEAN,
>
> ... some fields ...
> ADDED D_DATE,
> EDITED D_DATE,
> DBUSER D_USER
> );
>
> CREATE TRIGGER UTENTI_BOOL_TRIGGER FOR UTENTI
> ACTIVE BEFORE INSERT OR UPDATE POSITION 10
> AS
> BEGIN
> IF ( NEW.PERSGIU IS NULL ) THEN NEW.PERSGIU = 'F';
> END
> ;
>
> In C++Builder/Delphi i add my TIBOTable components, then i set this
> properties:
>
> ColumnAttributes = PERSGIU=BOOLEAN=T,F
> DefaultValues = UTENTI.PERSGIU=F
>
> Then i add all fields into TIBOTable Fields Editor, and i can see who
> PERSGIU are added as TBooleanFields.
> Now i can use my TBooleanFields without any problem.
>
> Enrico.
>
>
> > -----Original Message-----
> > From: IBObjects@yahoogroups.com
> > [mailto:IBObjects@yahoogroups.com] On Behalf Of Andrei Luís
> > Sent: Friday, November 04, 2005 7:10 PM
> > To: 'IBObjects@yahoogroups.com'
> > Subject: Re: [IBO] Converting BDE to IBO
> >
> >
> > Hi, I wrote something wrong...
> >
> > This: if tbCustomerActive then ....
> >
> > Should be this: if tbCustomerActive.asBoolean then ....
> >
> > :-)
> >
> > Andrei
> >
> > 2005/11/4, Andrei Luís <compuvale.software@...>:
> > > Hi to all,
> > >
> > > Finally I get sucess with TDBCheckBox, changing ValueChecked to 'T'
> > > and ValueUnchecked to 'F'.
> > >
> > > But, I have in this application, several times, boolean comparison,
> > > like if tbCustomerActive then .... This is still not
> > solved. How can
> > > I simulate those char fields as boolean?
> > >
> > > []
> > > Andrei
> > >
> > > 2005/11/4, Daniel Rail <daniel@...>:
> > > > Hi,
> > > >
> > > > At November 4, 2005, 9:18 AM, Andrei Luís wrote:
> > > >
> > > > > 2005/11/4, Helen Borrie <helebor@...>:
> > > > >> At 09:41 AM 4/11/2005 -0300, you wrote:
> > > > >> >Hi Helen,
> > > > >> >
> > > > >> >CREATE DOMAIN BOOLEAN AS
> > > > >> >CHAR(1) CHARACTER SET WIN1252
> > > > >> >DEFAULT 'N'
> > > > >> >CHECK (value in ('N', 'S'))
> > > > >> >COLLATE WIN1252
> > > > >> >
> > > > >> >I do the tests with two fields. One using the domain
> > above, and
> > > > >> >other field without domain. The result was the same: both 'N'
> > > > >> >(false) and 'S' (true) are handle as false!!! Tried
> > with 'T' and
> > > > >> >'F', and didn't works too.
> > > > >> >
> > > > >> >I don't know what is happen.
> > > > >>
> > > > >> Do you have these properties set in your DBCheckBox?
> > > > >>
> > > > >> DBCheckBox1.ValueChecked := 'S';
> > DBCheckBox1.ValueChecked := 'N';
> > > > >>
> > > > >> I don't think TDBCheckBox is specifically for Boolean
> > pairs like
> > > > >> TIB_CheckBox is...
> > > >
> > > > > Just changed that properties and still didn't work. I
> > used a lot
> > > > > of TDBCheckbox with Paradox, and it always works fine
> > with boolean
> > > > > fields. As I concern it is specially made for this.
> > > >
> > > > With TDBCheckBox, there are two properties that you can set in
> > > > design-time or in run-time(as Helen already pointed out). Those
> > > > properties are ValueChecked and ValueUnchecked. By default, they
> > > > are set to True and False, but they can be changed to
> > whatever value
> > > > you need. As an example, I assign them as follows
> > ValueChecked:='T'
> > > > and ValueUnchecked:='F'. You can use whatever value you need for
> > > > those properties. And, I did the same exercise 5 years
> > ago when I
> > > > migrated a Paradox application to Firebird using Delphi 5 and IBO.
> > > >
> > > > --
> > > > Best regards,
> > > > Daniel Rail
> > > > Senior System Engineer
> > > > ACCRA Group Inc. (www.accra.ca)
> > > > ACCRA Med Software Inc. (www.filopto.com)