ADO 怎样判断SQL
莫凡 2005-05-06 12:20:13 Dim SQL As String '//用于存储SQL语句
Dim SqlRs As ADODB.Recordset
Dim i, x, y As Integer '//用于循环
Dim Irowcount As Integer '//记录总数
Dim Icolcount As Integer '//字段总数
'//执行SQL
Set SqlRs = New ADODB.Recordset
SQL = strSQL
With SqlRs
.ActiveConnection = Cn
.CursorLocation = adUseClient
.CursorType = adOpenStatic
.LockType = adLockReadOnly
.Source = strSQL
.Open
If .RecordCount < 1 Then
Exit Function '//如果查询无数据的处理方法
Else
Icolcount = SqlRs.Fields.Count
Irowcount = SqlRs.RecordCount
SqlRs.MoveFirst '//记录移到首位
End If
End With
以上是我自制函数的部分原码,如果执行的是SELECT语句失可以返回记录集的,如果不是以上语句肯定是不对的,请问ADO可一判断是否执行的是SELECT语句呢?
拜谢!!!