Android Question Cursor as Parameter

Rob Bliss

Member
Licensed User
Longtime User
When passing a cursor as a parameter, when is the correct time(s) to close the cursor?

B4X: 
Sub main
    Dim v_Cursor as Cursor = SQL.ExecQuery("SELECT * FROM TABLE")
    func(v_Cursor)
    v_Cursor.Close   '?
End Sub

Sub func(p_Cursor as Cursor)
    p_Cursor.getString("column")
    p_Cursor.Close   '?
End Sub

Cheers
 
Sort by date Sort by votes

MarkusR

Well-Known Member
Licensed User
Longtime User
i would close it where u open it, in the same sub. its easier to understand.

just think about if you need this.
if u would close it in "func" u can't use "func" again.
B4X: 
Sub main
    Dim v_Cursor as Cursor = SQL.ExecQuery("SELECT * FROM TABLE")
    func(v_Cursor)
    func(v_Cursor)
    v_Cursor.Close
End Sub
 
Last edited:
Upvote 0
You must log in or register to reply here.

Similar Threads

R
  • Question
Android Question How to determine if cursor is at end of text in an edittext?
Replies
6
Views
543
jkhazraji
  • Question
Android Question SQL - ExecQuerySingleResult
Replies
2
Views
1K
jatko
A
  • Question
Android Question ExecQuery2
Replies
5
Views
2K
Mahares
M
  • Question
Android Question CursorIndex Out Of Bounds Exception
2
Replies
36
Views
6K
Erel
Bug? SQL Cursor.Getxxx
Replies
1
Views
993
Erel
Menu
Log in
Register
Cookies are required to use this site. You must accept them to continue using the site. Learn more…