Public Function UpdateDB() As Boolean
On Error Resume Next
Dim strsql As String
Dim rs As New ADODB.Recordset
'查询表QH检查是否有字段"切换点属性",不返回记录
strsql = "select [切换点属性] from qh where 0=1"
rs.Open strsql, dbConnection, adOpenKeyset, adLockReadOnly
rs.Close
Set rs = Nothing
If Err.Number = 0 Then '检查是否发生了错误,没有错误表示QH表中有此字段
UpdateDB = True
Exit Function
Else
Err.Clear
Public Function UpdateDB() As Boolean
On Error Resume Next
Dim strsql As String
Dim rs As New ADODB.Recordset
'查询表QH检查是否有字段"切换点属性",不返回记录
strsql = "select [切换点属性] from qh where 0=1"
rs.Open strsql, dbConnection, adOpenKeyset, adLockReadOnly
rs.Close
Set rs = Nothing
If Err.Number = 0 Then '检查是否发生了错误,没有错误表示QH表中有此字段
UpdateDB = True
Exit Function
Else
Err.Clear