B4J Question How to know when a resultset is empty?

wimpie3 · Oct 25, 2025

Is this a valid command to know if an SQL resultset is empty?

B4X:

If Not(ResultSet1.NextRow) then ...

As far as I know, nextrow moves to the next record, so my guess is that this if statement doesn't work as intended and that I might need to use an sql rowcount statement first.

DonManfred · Oct 25, 2025

- If you haven´t used it before it moves to the first row.

B4X:

If ResultSet1.NextRow then ' work with the data

should work.
- Resultset1 may be not initialized if it contains no data

wimpie3 · Sunday at 6:15 PM

I don't get it. Checking if Resultset1 contains no data is exactly what I'm trying to do... But using isInitialised doesn't work either.

LucaMs · Monday at 12:15 AM

B4X:

Public Sub IsResultSetEmpty(RS As ResultSet) As Boolean
    Dim Empty As Boolean = True
    Do While RS.NextRow
        Empty = False
        Exit
    Loop
    Return Empty
End Sub

It should be called as soon as a query is executed.

(When accessing DB it would be better to also use a Try-Catch)

B4J Question How to know when a resultset is empty?

wimpie3

Well-Known Member

DonManfred

Expert

wimpie3

Well-Known Member

LucaMs

Expert

Similar Threads

B4J Question How to know when a resultset is empty?

wimpie3

Well-Known Member

DonManfred

Expert

wimpie3

Well-Known Member

LucaMs

Expert

Similar Threads

Privacy & Transparency

Privacy & Transparency