Alexander Stolte Expert Licensed User Longtime User Sep 28, 2018 #1 Hello I heard that the "ResultSet" is cross platform. But why i need on B4A: B4X: 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.
Hello I heard that the "ResultSet" is cross platform. But why i need on B4A: B4X: 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 Expert Licensed User Longtime User Sep 28, 2018 #2 Position doesn't exist in ResultSet. You should use a code similar to this: B4X: Do While rs.NextRow Log(rs.GetString("col1")) Next RS.Close This works with B4A/B4i and B4J!
Position doesn't exist in ResultSet. You should use a code similar to this: B4X: Do While rs.NextRow Log(rs.GetString("col1")) Next RS.Close This works with B4A/B4i and B4J!
Erel B4X founder Staff member Licensed User Longtime User Sep 28, 2018 #3 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 is of course correct. You shouldn't use Position with ResultSet. It does exist in the B4A implementation because ResultSet inherits from Cursor.
klaus Expert Licensed User Longtime User Sep 28, 2018 #4 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.
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 Expert Licensed User Longtime User Sep 28, 2018 #5 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.
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 Expert Licensed User Longtime User Sep 28, 2018 #6 You should post post the code you use, without seeing what you are doing it's impossible to help! Why do you need Position?
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 Expert Licensed User Longtime User Sep 28, 2018 #7 ahhhhh i look in tho my B4I code, i forget this: klaus said: Do While rs.NextRow Log(rs.GetString("col1")) Next RS.Close Click to expand... sorry for my misstake.....
ahhhhh i look in tho my B4I code, i forget this: klaus said: Do While rs.NextRow Log(rs.GetString("col1")) Next RS.Close Click to expand... sorry for my misstake.....