>select * from mytable into cursor tmp where.......
>but mytable.dbf still open after tmp cursor formed
>is there any way to close mytable automatically after selected ?

Class to close any cursors created after it was instantiated.

But I guess that's not what you wanted. And I'm not sure you can do that - in case your cursor is just filtered, closing its base table may close the cursor too.