Android Question Cursor as Parameter

[Rob Bliss]

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

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

 

[MarkusR]

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.

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

 

[mc73]

What is func really supposed to do?

 

[Rob Bliss]

What is func really supposed to do?

Could be anything, was just an example