Francois,

for the IB_CHECKBOX, try this :

double click on the IB_QUERY that the checkbox is attached to via the
DataSource proprty.
click on the 'light bulb' icon to prepare the dataset
click on the Column Attributes tab
On the left side, selct the field you wish to be boolean
Check the boolean field, and enter '1' and '0' for the True text and False
Text.
Click OK.

in the database you can define a domain for booleans similar to the
following :

CREATE DOMAIN MY_LOGICAL CHAR( 1 ) DEFAULT 'F' NOT NULL
CHECK(VALUE IN ('F','T'));

then define your boolean field using the above domain :

CREATE TABLE WHATEVER (
...
...
BOOL_FIELD MY_LOGICAL,
...
...
);



HTH

Norman.


----------------------------------------------------------------------------
----
Norman Dunbar EMail: NDunbar@...
Database/Unix administrator Phone: 0113 289 6265
Lynx Financial Systems Ltd. Fax: 0113 201 7265
URL: http://www.LynxFinancialSystems.com
----------------------------------------------------------------------------
----


-----Original Message-----
From: Francois Leemans [mailto:lee@...]
Sent: Tuesday, June 12, 2001 10:16 AM
To: IBObjects
Subject: [IBO] Checkbox and datetimepicker question


<SNIP>

I can not find how I can make a field in a database boolean (is this a
unknown field type in interbase ?)
So I made a integer field with the values 0 and 1
I want to use the IB_Checkbox with this field since I want my users to be
able to check this field instead of entering a 0 or 1
With the regular Delphi component I have the properties (valuechecked and
valueunchecked)
In the IB_Checkpox I mis those properties.
How do I tell the IB_Checkbox that 0 is unchecked and 1 is checked ?

Lee