SOS SOS SOS SOS,救救我吧!
Times 2000-01-27 05:16:00 我在INTERBASE里先建了这么一个表:
CREATE TABLE MIS_OBJ_TYPE (OBJ_TYPE_ID DOUBLE PRECISION NOT NULL,
OBJ_TYPE_NAME VARCHAR(32) NOT NULL,
SUPER_OBJ_TYPE_ID DOUBLE PRECISION NOT NULL,
OBJ_TYPE_TAB_SCHEMA VARCHAR(32),
OBJ_TYPE_TAB_NAME VARCHAR(32),
OBJ_TYPE_CAN_MODIFY CHAR(1) DEFAULT 'T'
NOT NULL,
OBJ_TYPE_CAN_DELETE CHAR(1) DEFAULT 'T'
NOT NULL,
OBJ_TYPE_FLAG DOUBLE PRECISION DEFAULT 0
NOT NULL,
OBJ_TYPE_DISP_IND DOUBLE PRECISION DEFAULT 1
NOT NULL,
OBJ_TYPE_CODE CHAR(16) DEFAULT '****************'
NOT NULL,
PRIMARY KEY (OBJ_TYPE_ID));
在建下表时,报这个错:unsuccessful metadata update
-object MIS_OBJ_TYPE is in use
为什么!!!!!!
CREATE TABLE MIS_OBJ_OBJ (
OBJ_ID NUMERIC(11, 0) NOT NULL,
OBJ_TYPE_ID NUMERIC(11, 0) NOT NULL,
OBJ_NAME VARCHAR(64) NOT NULL,
PARENT_OBJ_ID NUMERIC(11, 0) NOT NULL,
OBJ_DISP_IND NUMERIC(11, 0) DEFAULT 1 NOT NULL,
OBJ_NOTE VARCHAR(64),
OBJ_CAN_MODIFY CHAR(1) DEFAULT 'T' NOT NULL,
OBJ_CAN_DELETE CHAR(1) DEFAULT 'T' NOT NULL,
OBJ_MODEL_ID NUMERIC(11, 0),
OBJ_FULLNAME VARCHAR(1024),
PRIMARY KEY(OBJ_ID),
FOREIGN KEY ( OBJ_TYPE_ID) REFERENCES MIS_OBJ_TYPE(OBJ_TYPE_ID)
)