You can use the CursorAdapter.CursorDetach() method to free the table. But I see no reason you need to destroy the oCursor object. You can connect and disconnect as needed with the CA class.



>>>
>>>1) When the object oCursor is destroyed, the table closes. Any way
>>>to make it persist?
>>
>>This makes sense to me as the lifetime of the CA should be the same as the cursor.
>
>If the cursor object is left open, and it's SQL data, isn't this holding a
>connection to the database? We will want to use disconnected data. It seems to me
>that you would want to call this code in some generic format, only being used long
>enough to return the desire data, and having it persistant would make this difficult.
>
>>