February 9th, 2005, 08:50 AM
|
|
Contributing User
|
|
Join Date: Jan 2005
Posts: 66
Time spent in forums: 1 Day 2 h 40 m 23 sec
Reputation Power: 4
|
|
|
error 335544351
Code:
CREATE TABLE Main (
Uniq_WoodPiece_Number BIGINT NOT NULL PRIMARY KEY,
WOOD_STATUS As Smallint,
Prog_ID For_Prog_ID,
Lenght FLOAT,
Width FLOAT,
Saw_1 FLOAT,
Saw_2 FLOAT,
Angle_1 FLOAT,
Angle_2 FLOAT,
Queue_Control BIGINT,
JobList_Num INTEGER NOT NULL,
FOREIGN KEY (Prog_ID) REFERENCES Progs (Prog_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (Prog_ID) REFERENCES Progs (Prog_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (Prog_ID) REFERENCES Progs (Prog_ID)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (JobList_Num) REFERENCES JobList (JobList_Number)
ON UPDATE CASCADE
ON DELETE CASCADE,
FOREIGN KEY (WOOD_STATUS) REFERENCES WOOD_STATE (STATE_ID)
ON UPDATE CASCADE
ON DELETE CASCADE
I have such a error during this operation:
"unsucceful metadata update
could not find UNIQ INDEX with specified column"
HELP !!
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
