Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

Guest_imported

New member
Joined
Jan 1, 1970
Messages
0
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top