>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 ?
lcCursor = "mytable"
select Cur1.* from (lcCursor) AS Cur1 into cursor tmp where Cur1.Field1 # nn .......
USE IN SELECT(lcCursor)
So you simply need to use the
alias Cur1 inside the SQL SELECT.
:)
Words are given to man to enable him to conceal his true feelings.
Charles Maurice de Talleyrand-Périgord
Weeks of programming can save you hours of planning.
OffThere is no place like [::1]