Add the REQUIRED column attribute along with the BOOLEAN. This tells IBO
that NULL isn't expected as a value.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Lukas Zeller" <luz@...>
To: <IBObjects@egroups.com>
Sent: Monday, January 15, 2001 11:20 AM
Subject: [IBO] How to avoid third state (NULL) in Grid Checkboxes?


I have a TIB_Grid which displays some boolean fields (SMALLINTs,
0=false, 1=true) as checkboxes. This works fine except that
clicking the checkboxes does not toggle between true and false,
but between true, false and grey (underlying field = NULL).
How can I avoid the third state?

I have set the BOOLEAN ColumnAttribute and also defined the
true and false values as 1 and 0 for the SMALLINT field.

What could be wrong?

Lukas Zeller (luz@...), Direktwahl +41 1 440 66 01
--
Synthesis AG, Rosengartenstr. 1a, 8037 Zürich
Tel: +41 1 440 66 00, Fax: +41 1 440 66 04
info@..., http://www.synthesis.ch