B4J Question How to know when a resultset is empty?

[wimpie3]

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

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]

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

If ResultSet1.NextRow then ' work with the data

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

 

[wimpie3]

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]

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)