比如: Dim DefDatabase As Database Dim DefTable As TableDef, DefField As Field Set DefDatabase = Workspaces(0).OpenDatabase(App.Path & "\www.mdb", 0, False) Set DefTable = DefDatabase.CreateTableDef(www) Set DefField = DefTable.CreateField("id", dbInteger, 2) 我想知道如何建立自动编号字段??有谁知道啊
Dim db As New Connection db.ConnectionString = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data\data.mdb;Persist Security Info=False" db.CursorLocation = adUseClient db.Open db.Execute "Create Table " & 表名 & "([id] Counter,[时间] Date,[实测温度] Single,[温度偏差] Single,Constraint StatePrimary Primary key ([id]))"
CREATE TABLE dbo.TABLE2 id int NOT NULL IDENTITY (1, 1), test varchar(50) NULL嘿嘿,这是SqlServer的语法,Asccess不知道能不能用,我去试一下~
Dim OpenDataBaseFile As Database Dim DataBaseTableDef As TableDef Dim DataBaseField As FieldSet OpenDataBaseFile = CreateDatabase("FileName", dbLangGeneral)Set DataBaseTableDef = OpenDataBaseFile.CreateTableDef("Library")
Set DataBaseField = DataBaseTableDef.CreateField("ID", dbLong) DataBaseField.Attributes = dbAutoIncrFieldDataBaseTableDef.Fields.Append DataBaseField
呵呵,终于找到了,试试运行下面的查询:CREATE TABLE TABLE2 (id GUID)
先查字段中数据的最大值,令最大值加1,如无数据则为1 sql = "select max(num) as a from renyuan" Set rs = conn.Execute(sql) If Not rs.EOF Then maxblh = rs!a+1 Else maxblh = 1 End If
accsess数据库
Dim DefDatabase As Database
Dim DefTable As TableDef, DefField As Field
Set DefDatabase = Workspaces(0).OpenDatabase(App.Path & "\www.mdb", 0, False)
Set DefTable = DefDatabase.CreateTableDef(www)
Set DefField = DefTable.CreateField("id", dbInteger, 2)
我想知道如何建立自动编号字段??有谁知道啊
db.ConnectionString = " Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\data\data.mdb;Persist Security Info=False"
db.CursorLocation = adUseClient
db.Open
db.Execute "Create Table " & 表名 & "([id] Counter,[时间] Date,[实测温度] Single,[温度偏差] Single,Constraint StatePrimary Primary key ([id]))"
Dim DataBaseTableDef As TableDef
Dim DataBaseField As FieldSet OpenDataBaseFile = CreateDatabase("FileName", dbLangGeneral)Set DataBaseTableDef = OpenDataBaseFile.CreateTableDef("Library")
Set DataBaseField = DataBaseTableDef.CreateField("ID", dbLong)
DataBaseField.Attributes = dbAutoIncrFieldDataBaseTableDef.Fields.Append DataBaseField
sql = "select max(num) as a from renyuan"
Set rs = conn.Execute(sql)
If Not rs.EOF Then
maxblh = rs!a+1
Else
maxblh = 1
End If
zzzwww(西蜀)的方法是正确的