>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 ?

I am not sure I would brave enough to use it, but this seems to do the trick

select * from mytable into cursor tmp where somCondition nofilter having closeSource('mytable')


function closeSource(tcAlias as String) as Boolean
	use in select(tcAlias)
	return .t.
endfunc

(This will be called a gazillion times for doing one thing, so I would not recommend it as it offers very little in return, but it does what you want :)