Hi

I m not looking for a way to see the cursors/tables.

I dont want to open tables again and again, For example if I have a queries form with 'preview' command buttun, the query run on the opend tables and in the procedure I created cursors, now the user want to run the query again on other ids range, I have to close all the cursors procedure but I don't want to close the tables and I dont want to close the other opend cursor (example, I have a cursor for list box).

This example show you the problem principle.

I dont want to open the tables every form, I fust use with set order to my indexes and to close only the temp cursors (exept my tables and some cursors).


>aused() will give you an array of open aliases. You will have to go through this array, and check each table to see whether you want it closed or not.
>
>I usually don't worry much about open tables; for example, if a form closes, its tables get closed automatically. Using a private datasession, of course.
>
>>Hi all
>>
>>I used to open all the database tables when the user start the application.
>>
>>When ever I have to use with cursors I have to close it manually (use in..) in the procedure end, I cant close all the data because I need the tables open and sometimes I need few cursors open.
>>
>>How can I tell vfp to close all without ...
>>
>>The direction is with this way:
>>
>>I have a table with column 'tables' - all of the my tables apeared in this column.
>>
>>I have to tell vfp 'close all the tables/cursors, but dont close the tables that apear in my table and dont close all the files that I sent you by additional parameter.
>>For example: By calling the function 'closetemp' like this: closetemp(abc,dre,hsy,fju) I will close all tables/cursors except the tables that apear in my table and the tables/cursors abc,dre,hsy,fju.
>>(sometimes I can have 1,5,10 additional cursors or nothing).
>>
>>Thank's