Bug? Resultset on B4A need a position?

[Alexander Stolte]

Hello

I heard that the "ResultSet" is cross platform. But why i need on B4A:

Dim rs as ResultSet
rs.position = 0

why i need the "rs.position", on B4I the position is not exist, Now I have to use #If B4A anyway to fix this case.

Is it wanted like that? Thanks.

 

[klaus]

Position doesn't exist in ResultSet.
You should use a code similar to this:

Do While rs.NextRow
    Log(rs.GetString("col1"))
Next
RS.Close

This works with B4A/B4i and B4J!

 

[Erel]

Klaus is of course correct. You shouldn't use Position with ResultSet. It does exist in the B4A implementation because ResultSet inherits from Cursor.

 

[klaus]

As I am using ResultSet, I didn't even notice that ResultSet.Position does exist.
Erel I think that you should remove it, because I'm afraid that it brings more confusion than andvantages.

 

[Alexander Stolte]

before i create this thread i remove all my ".position = 0" from the code and the app is crahsing because, i need to set a ".position" in B4A.

 

[klaus]

You should post post the code you use, without seeing what you are doing it's impossible to help!
Why do you need Position?

 

[Alexander Stolte]

ahhhhh i look in tho my B4I code, i forget this:

Do While rs.NextRow
Log(rs.GetString("col1"))
Next
RS.Close

sorry for my misstake.....