H
hs125
Unregistered / Unconfirmed
GUEST, unregistred user!
[][] 小弟近日在作一小MIS,用Interbase做的数据库,表是用Interactive SQL写的,用BDE连接,
一个Table控件对应该表,而当设该表Active属性为True时报错:
General SQL error.
Column unknow
DATE_OPEN
Client SQL dialect 1 does not support reference to
DATE datatype
该表用Interbase Interactive SQL作成,语句为:
CREATE TABLE CASE(
ID CHAR(12) NOT NULL,
DATE_OPEN DATE,
RESULT VARCHAR(50),
CONSTRAINT CASE_ID PRIMARY KEY(ID)
);
一个Table控件对应该表,而当设该表Active属性为True时报错:
General SQL error.
Column unknow
DATE_OPEN
Client SQL dialect 1 does not support reference to
DATE datatype
该表用Interbase Interactive SQL作成,语句为:
CREATE TABLE CASE(
ID CHAR(12) NOT NULL,
DATE_OPEN DATE,
RESULT VARCHAR(50),
CONSTRAINT CASE_ID PRIMARY KEY(ID)
);