Microsoft][ODBC Microsoft Access 驱动程序] CONSTRAINT 子句语法错误。

最新推荐文章于 2022-03-05 19:27:50 发布

君行早

最新推荐文章于 2022-03-05 19:27:50 发布

阅读量1.4k

点赞数

本文链接：https://blog.csdn.net/u011272889/article/details/17757225

版权

ASP中用SQL语句在Access中建表如下：

            Application("gDBConn").Execute("CREATE TABLE student([number] VARCHAR(8) PRIMARY KEY,[sname] VARCHAR(10),[grade] SMALLINT,[sex] VARCHAR(1),[department] VARCHAR(10) )")
              Application("gDBConn").Execute("CREATE TABLE book([book_number] VARCHAR(30) PRIMARY KEY,[bname] VARCHAR(30),[publish] VARCHAR(30),[pdate] DATE,[book_count] INT,[author] VARCHAR(20),abstract VARCHAR(100))")
              Application("gDBConn").Execute("CREATE TABLE lendb([number] VARCHAR(8),[book_number] VARCHAR(30),[ldate] DATE,[rdate] DATE,[bname] VARCHAR(30),PRIMARY KEY ([number],[book_number]),FOREIGN KEY (number) REFERENCES student([number]),FOREIGN KEY ([book_number]) REFERENCES book([book_number]))")

其中红色属性没有加[]而出现了CONSTRAINT 子句语法错误。加上后就没有错误了。