DAO建库问题,急用!!!!! Set MyField = MyTable.CreateField("Num", ???????) MyTable.Fields.Append MyField 用DAO建库里遇到过问题,我要建 AutoNumber 类型的字段,就是自动增量字段,不知道该怎么建立?????? 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 实现代码如下:SQL = "CREATE TABLE [dbo].[DeviceType] (" & _ "[ID] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY," & _ "[Sort] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ," & _ "[Content] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL " & _ ") ON [PRIMARY]"Conn.Execute SQL其中:"[ID] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY为自增长的主键 上面情况是针对SQL数据库,ACCESS数据库中实现方法如下:SQL = "CREATE TABLE [DeviceType] (" & _ "[ID] COUNTER NOT NULL, " & _ "[Sort] Text(50) NOT NULL DEFAULT 测试," & _ "[Content] Text(50) NOT NULL ,PRIMARY KEY(ID)) " Conn.Execute SQL PostMessage模拟后台鼠标点击的问题 比较色的人进来 请教怎么判断我指定路径的文件是否存在 怎样使用模糊查询表名呢?请大虾帮忙 无规律提示“类Worksheet的Paste 方法无效”的问题 哪位有时间开发个小程序? vb高手帮忙---vb程序中建立ado和ODBC连接的区别 如何将0.5存入数据库? webbrowser 中 NavigateComplete2 和 NavigateComplete的区别是什么? 如何判断一台远程服务器的某个程序正在运行? 怎样实现窗体显示时,在任务条上不出现相应按钮 那裡有介紹vb 編寫組件的資料,重謝!分不是問題
SQL = "CREATE TABLE [dbo].[DeviceType] (" & _
"[ID] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY," & _
"[Sort] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ," & _
"[Content] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL " & _
") ON [PRIMARY]"
Conn.Execute SQL其中:"[ID] [int] IDENTITY (1, 1) NOT NULL PRIMARY KEY为自增长的主键
SQL = "CREATE TABLE [DeviceType] (" & _
"[ID] COUNTER NOT NULL, " & _
"[Sort] Text(50) NOT NULL DEFAULT 测试," & _
"[Content] Text(50) NOT NULL ,PRIMARY KEY(ID)) "
Conn.Execute SQL