>>>>>I have 4 questions about using DE.
>>>>>
>>>>>1. If I have a view in the DE, do I still need to open the base tables of the view in the DE? Any implication if I have some of tables open in the DE? Do I need to set buffering off?
>>>>
>>>>YOu don't need to open a view's tables. Like SQL, views are pretty good at taking care of themselves. I don't believe any special considerations need to be made for buffering.
>
>What if it is updateable view? If the underlying table is in buffering mode, I have to do tableupdate for the underlying tables, right?
>
>>>>>3. Where should I close those cursors open by comboboxes.
>>>>
>>>>I'm not sure what you mean by 'open by comboboxes'. Do you mean if the rowsource of the combobox is SQL?
>>>>
>
>Yes, when it is SQL and I have Select ... Into Cursor xxx. The cursor will remain open even after I release my form. Where should I do cleanup in this case?
>
>>>>>4. Also sometimes, even some tables in DE seem to stay open when I start calling from a form to another form. Where should I do cleanup?
>>>>
>>>>The answer to this question is highly dependent on your use of private or default datasessions in your forms. In either case though, you shouldn't have to do cleanup, because when a form releases, it closes any tables that it opened for its DE.
>>>>When using the default datasession though, all forms using the default datasession can access the same tables, even though they might not be opened by their DE. I personally prefer to use private datasessions, and pass record numbers from orm to form, rather than worry about one form changing the record pointer on a table that another form is using. Read up on datasessions in the manual, and let us know if you have more questions.
>
>I actually have some tables in the DE that stays open after I release the form. That is what prompted question 4.

Default or private datasessions?
Autoclosetables = ?

How are you verifying that the tables are open? With the Data Session Window?