>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 :)
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?
"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare
"To die for a religion is easier than to live it absolutely"
Jorge L. Borges