B4J Code Snippet SQL rowcount

To get the number of rows returned by a query without having to traverse the whole resultset

Sub rowCount(rs As JavaObject) As Int
   rs.RunMethodJO("last",Null)
   Dim count As Int = rs.RunMethod("getRow",Null)
   rs.RunMethod("beforeFirst",Null) 
   Return count
End Sub

Use preferably before

   do while rs.NextRow

call with

   Log(rowCount(c1)) ' c1 is the resultset

 

[Erel]

Whether it will work or not depends on the JDBC driver. Many, if not most drivers will return a forward only cursor. Such cursor cannot jump to the last or first row.

 

[ThRuST]

You can also use

SELECT Count(*) FROM TABLE

 

[KMatle]

You can also use

Standard