I'm trying to get to grips with Interbase6/D5. For some reason I can't get records to produce default values.
CREATE TABLE "TEST"
"P1" VARCHAR(10) NOT NULL,
"U1" VARCHAR(31) DEFAULT USER,
"T1" VARCHAR(5) DEFAULT 'abcde',
"BLAH" DATE DEFAULT 'NOW',
CONSTRAINT "PK_P1" PRIMARY KEY ("P1")
Nothing gets given a default value when I do a new record, not even in IBConsole.
Any ideas what I'm doing wrong ?
Do I have to set triggers or something ?