Subject IB_Checkbox and grayed state
Author Adrian Wreyford
How can I prevent the IB_ComboBox from displaying in the grayed state when
the dataset enters the insert state.



I use the following table:

CREATE TABLE CONTACTS (

CONTACTID INTEGER NOT NULL,

CONTACTSURNAME VARCHAR(30),

CONTACTTYPEVENDOR CHAR(1) DEFAULT 'F',

CONTACTTYPESERVPROV CHAR(1) DEFAULT 'F',

CONSTRAINT CONTACTS_PK PRIMARY KEY (CONTACTID)



I use Contacttypevendor as the datafield for the IB_Combobox.



I would expect it to default to blank (or unticked), as the default value is
�F� when a new record is inserted, but instead it defaults to �Null� which
is the grayed state.



I can circumvent this with an AfterInsert event,

And

IB_Query1.FieldByName(�Contacttypevendor�).AsString := �F�;



But don�t understand why the default value in the metadata is not used.



Thanks in advance



Adrian






--
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.344 / Virus Database: 267.10.23/99 - Release Date: 2005/09/12



[Non-text portions of this message have been removed]