Question

VB中判断SQl表是否为空

Sub openrs(rs As ADODB.Recordset, sqlstr As String)
Set rs.ActiveConnection = db
rs.CursorLocation = adUseClient
rs.CursorType = adOpenDynamic
rs.LockType = adLockOptimistic
rs.Source = sqlstr
rs.Open
End Sub

If rs1.State <> adStateClosed Then rs1.Close
Call bas.openrs(rs1, "SELECT COUNT(*) AS a From table")

反回的 a 为什么是NULL

Answer 1

参考答案 8. 小时候最喜欢玩捉迷藏了，等他们都藏好了，我就回家吃饭.

Answer 2

因为没有，所以返回NULL咯