>>>I am trying to get all aliases in all sessions no matter what the sourceType is. asessions() and aused() doesn't return the information I need. Is there a way?
>>>TIA
>>>Cetin
>>
>>Solved. Although there is not a visible alias, it was the CursorAdapter keeping handle alive.
>
>IOW, closing the table isn't really closing it until its CA is released? Didn't know that, but then it's been only a few months since I started playing with CAs occasionally.
>
>This is a very interesting finding. I think the CA is very poorly documented in help, and most of the knowledge about it comes from other sources, mostly our collective trial and terror...
>
>Thanks for wasting your nerves on behalf of the community :).
Yes, exactly and I am not really sure the table was closed or not (I didn't find a place where I closed it but didn't dig very much either once solved). I would think that it was closed somewhere. Unless you also explicitly/implicitly close the datasource (Ca.Datasource) it isn't really freed.
PS: Not only nerves but hair is wasted as well:)
Cetin