>>The tables remain open while the form is open. It might be efficient to >close the tables that are no longer used - Walter Meester published a test >which demonstrates that keeping many tables open will slow Visual FoxPro >down considerable! But I am not sure whether this applies to tables opened >in different datasessions
>
>Finally I found a solution. I was always thinking that the command CLOSE TABLES close all tables in memory but it close only the tables of the courant database and not cursors issued from a query. After I mad my query I use CLOSE TABLES and all tables associated to this query close.
>
>Thanks for your help.
According to help, CLOSE TABLES "Closes all tables in the currently selected database." This may include other tables, apart from the tables related to a specific query - including tables you opened manually.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)