I can not manage to force a field to be bigger than 0 (zero). Below is my
script:
CREATE TABLE "OZLER"."LOT_TAKIP"
(
"REF" Fixed (10,0) NOT NULL DEFAULT SERIAL (1),
"SILO" Char (25) ASCII NOT NULL,
"LOT" Char (25) ASCII NOT NULL,
"HAMMADDE" Char (25) ASCII NOT NULL,
"TOPLAM" Float (20) NOT NULL DEFAULT
0.0000000000000000000E+00,
"KALAN" Float (20) NOT NULL DEFAULT
0.0000000000000000000E+00,
"KAPANDI" Char (1) ASCII NOT NULL,
"DOLUM_ZAMANI" Timestamp NOT NULL DEFAULT TIMESTAMP,
"SON_CIKIS_ZAMANI" Timestamp NOT NULL DEFAULT
TIMESTAMP,
PRIMARY KEY ("REF"),
CONSTRAINT "KAPANDI_LOT_TAKIP" CHECK "KAPANDI" IN ('E','H'),
CONSTRAINT "KALAN_LOT_TAKIP" CHECK ("KALAN" > 0),
FOREIGN KEY "SILOLAR_LOT_TAKIP" ("SILO") REFERENCES "OZLER"."SILOLAR"
("KOD") ON DELETE RESTRICT,
FOREIGN KEY "HAMMADDE_LOT_TAKIP" ("HAMMADDE") REFERENCES
"OZLER"."HAMMADDELER" ("KOD") ON DELETE RESTRICT
)
I have error for " CONSTRAINT "KALAN_LOT_TAKIP" CHECK ("KALAN" > 0),"
Error message is: "General error;-8009 POS(774) DEFAULT value must be in
constraint specification:KALAN_LOT_TAKIP."
My SapDB version is: 7.4.3.27.
I do not seem to find out what I am doing wrong. Any help will be
appreciated.
Regards,
--
Ertan Kucukoglu
[EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
