Rss & SiteMap

Foxtable(狐表) http://www.foxtable.com

新一代数据库软件,完美融合Access、Foxpro、Excel、vb.net之优势,人人都能掌握的快速软件开发工具!
共2 条记录, 每页显示 10 条, 页签: [1]
[浏览完整版]

标题:Access中sql执行语法错误

1楼
811233895 发表于:2024/8/5 19:55:00
Dim s As String =" CREATE TABLE User ([_Identify] AUTOINCREMENT PRIMARY KEY, UserName TEXT(255), Password TEXT(100), FullName TEXT(100), 软件类型 TEXT(100), MobilePhone TEXT(100), Creator TEXT(50),CreateTime DATETIME, Role TEXT(20),[AuditStatus] YesNo)"
Functions.Execute("ExecuteReader","MainMdb",s,False)
在Access环境中,这句能执行,但是在Ft中没有办法执行,提示语法错误!
2楼
有点蓝 发表于:2024/8/5 21:58:00
加上中括号

CREATE TABLE [User] ([_Identify] AUTOINCREMENT PRIMARY KEY, [UserName] TEXT(255), [Password] TEXT(100), [FullName] TEXT(100), [软件类型] TEXT(100), [MobilePhone] TEXT(100), [Creator] TEXT(50),[CreateTime] DATETIME, [Role] TEXT(20),[AuditStatus] YesNo)
共2 条记录, 每页显示 10 条, 页签: [1]

Copyright © 2000 - 2018 foxtable.com Tel: 4000-810-820 粤ICP备11091905号

Powered By Dvbbs Version 8.3.0
Processed in .01563 s, 2 queries.