If I used CursorDetach, what would be the point of leaving the cursor object active?

Also, if I detach, I assume that would disconnect it from the SQL connection?


>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.
>>
>>>