>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

If you make a cursor, then you close it at the end. That's clear and transparent rule. If you want to use some cursor in different methods of the same form, then you create it in Form.Load event and close it in Form.Unload event. Stick to this rule, it's a part of the framework.