>Thanks for the answer. I had tried something like that but not always works. I assume that it is because for small tables a real dbf is not created. What I have noticed is that if I open a view in the default datasession and the open it again in the private one the query is not reevaluated. I haven't found anything to explain this behavior but it seems to work. The code I am using in my "zoom" combo base class is:
>
>* open the table
>* if we are using it with zoom_DataStore = .t.
>* open it in the default datasession
For views you could just Use (view_name) again alias (.zoom_datastore), should be faster, because it assumes identical data (i.e. not pulling data again). I've tried this with a view which normally pulls few thousand records, and use.. again works instantly. Though, in this case your app should know which of these are views and which are not - you can always check DBGetProp (or was it in CursorGetProp... I always have to look in help to distinguish them).
Ciao