如何测试recordSet是否为空?一片空白? [英] How do I test if a recordSet is empty? isNull?

问题描述

如何测试记录集是否为空?

How can you test if a record set is empty?

        Dim temp_rst1 As Recordset
        Dim temp_rst2 As Recordset

        Set temp_rst1 = db.OpenRecordset("SELECT * FROM ORDER_DATA WHERE SKUS_ORDERED = '" & curSKU1 & "' AND [ORDER] = " & curOrder)
        Set temp_rst2 = db.OpenRecordset("SELECT * FROM ORDER_DATA WHERE SKUS_ORDERED = '" & curSKU2 & "' AND [ORDER] = " & curOrder)

        If IsNull(temp_rst1) Or IsNull(temp_rst2) Then MsgBox "null"

我正在基于一条select语句打开几个记录集.如果没有记录，则IsNull返回true吗?

I'm opening up a couple of record sets based on a select statement. If there are no records, will IsNull return true?

推荐答案

我会检查文件结束"标志:

I would check the "End of File" flag:

If temp_rst1.EOF Or temp_rst2.EOF Then MsgBox "null"

这篇关于如何测试recordSet是否为空?一片空白?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！