'DEFAULT' declared not auto-filled a field with default value!!

[Guest_imported]

Dear all plx help,

I declared a column with default values, for example:
=======================================
CREATE DOMAIN KEYWORDFLAG AS CHAR(1)
default 'F';

/* Table: TOPIC, Owner: SYSDBA */

CREATE TABLE a
(
X TIMESTAMP,
xx TIMESTAMP,
xxx TIMESTAMP,
xxxx INTEGER NOT NULL,
xxxxx SMALLINT,
xxxxxx SMALLINT,
xxxxxxx VARCHAR(255),
xxxxxxxx VARCHAR(255),
field9 KEYWORDFLAG,
PRIMARY KEY (TOPICID)
);
====================================
I initially think that by declaring a column to hold default, the field9 above should be able to auto-fill by the specified default values.

But it can't, can anyone tell me how to make interbase field auto-filled(say if I don't input 'T' or 'F', field9 will fill itself with default 'F').

Thank you.

judy Chan

 

[MartijnTonies]

When and where doesn't it use the default?

DEFAULTs are only used when the column is not part of an INSERT statement.

Martijn Tonies
InterBase Workbench - the developer tool for InterBase and Firebird

http://www.interbaseworkbench.com