Private Sub Command7_Click()
CTS_sql = "SELECT * FROM cts_sell"
MSFlexGrid1.DataSource = cts_select(CTS_sql) 提示:实时错误'13'类型不匹配.这是为什么呀!大家都来帮我瞧下呀
MSFlexGrid1.Refresh
End Sub
Public Function cts_select(cts_string As String) As ADODB.Recordset
On Error GoTo cts_error
Set CTS_cn = New ADODB.Connection
Set CTS_rst = New ADODB.Recordset
CTS_cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=CTS_vendition;Data Source=cts-t"
CTS_cn.Open
Set CTS_rst.ActiveConnection = CTS_cn
CTS_rst.LockType = adLockOptimistic
CTS_rst.CursorType = adOpenKeyset
CTS_rst.Open Trim(cts_string)
Set cts_select = CTS_rst
Set CTS_rst = Nothing
Set CTS_cn = Nothing
Exit Function
cts_error:
If cts_error(Err.Description) Then
Resume
Else
End
End If
End Function
CTS_sql = "SELECT * FROM cts_sell"
MSFlexGrid1.DataSource = cts_select(CTS_sql) 提示:实时错误'13'类型不匹配.这是为什么呀!大家都来帮我瞧下呀
MSFlexGrid1.Refresh
End Sub
Public Function cts_select(cts_string As String) As ADODB.Recordset
On Error GoTo cts_error
Set CTS_cn = New ADODB.Connection
Set CTS_rst = New ADODB.Recordset
CTS_cn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=CTS_vendition;Data Source=cts-t"
CTS_cn.Open
Set CTS_rst.ActiveConnection = CTS_cn
CTS_rst.LockType = adLockOptimistic
CTS_rst.CursorType = adOpenKeyset
CTS_rst.Open Trim(cts_string)
Set cts_select = CTS_rst
Set CTS_rst = Nothing
Set CTS_cn = Nothing
Exit Function
cts_error:
If cts_error(Err.Description) Then
Resume
Else
End
End If
End Function
CTS_cn.CursorLocation =adUseClient
我没分了555555555555555555555555555555555555
不知是不是不这样!望试试!
'Set CTS_rst = Nothing '把这两句去除掉吧试试
'Set CTS_cn = Nothing '
'不知是不是第一句因为只拷贝一个句柄,而没有把Recordset整个对像拷贝过来.猜测中,望多星高人指点迷经
最前面加一条
Dim CTS_SQL As String
而且前面还是应该加上Set
Set MSFlexGrid1.DataSource = cts_select(CTS_sql) 提示:实时错误'13'类型不匹配.这是为什么呀!大家都来帮我瞧下呀
Option Explicit