sql server 2000,判斷某個表是否存在某個字段select * from syscolumns where name='字段名' and id=object_id('表名')
可以用错误来判断 On Error GoTo Err: exit sub err: If Err.Number = 3265 Then MsgBox "字段不存在" 下面建造字段 resume next '回到原错误的下面继续执行
用filter函数来查找。 Public mrc As ADODB.Recordset mrc.open "select from....." If mrc.RecordCount > 0 Then mrc.filter ="字段1="&text1.text if mrc.recoracount>0 then msgbox "输入重复" else **输入结果** end if end if
看這個行不行:Dim Rs as new adodb.recordset dim strSQL as string Dim Table As TableDef Dim Field As Field strsql="select * from syscolumns where name='字段名' and id=object_id('表名')" With Rs .open strsql,connection,adOpenStatic ,adLockReadOnly if .eof=true then Set Table = Database.CreateTableDef("表名") Set Field = Table.CreateField("字段名", 字段類型, 長度) Table.Fields.Append Field '添加到表中 End if End With Rs.Close Set Rs=Nothing
On Error GoTo Err:
exit sub
err:
If Err.Number = 3265 Then MsgBox "字段不存在"
下面建造字段
resume next '回到原错误的下面继续执行
Public mrc As ADODB.Recordset
mrc.open "select from....."
If mrc.RecordCount > 0 Then
mrc.filter ="字段1="&text1.text
if mrc.recoracount>0 then
msgbox "输入重复"
else
**输入结果**
end if
end if
dim strSQL as string
Dim Table As TableDef
Dim Field As Field
strsql="select * from syscolumns where name='字段名' and id=object_id('表名')"
With Rs
.open strsql,connection,adOpenStatic ,adLockReadOnly
if .eof=true then
Set Table = Database.CreateTableDef("表名")
Set Field = Table.CreateField("字段名", 字段類型, 長度)
Table.Fields.Append Field '添加到表中
End if
End With
Rs.Close
Set Rs=Nothing