>Jeff,
> You can close the tables opened by the SELECT statement by saying USE IN TableAlias where TableAlias is the alias of the table(s) opened by the SELECT statement. This can be done for each table openede. Alternatively, you can say SELECT TableAlias, followed by USE to close each table in turn.
>
>Bill
>
>
>>I've tried everything suggested, but nothing seems to be working. I think the problem is that the SELECT statements leave the table open, even though I issue a USE statement to close the tables after the final SELECT statement. How do I close the tables that the SELECT statment opened?
>>
>>>Jeff, Check where you have put the Set Index statement, and be sure your syntax is correct for the type of index - for instance, if you have a CDX index, you'd use SET ORDER TAG xxx
>>>
>>>You can try moving the Set Index To xxxx up into the if clause, right after the USE pd_payments command.
>>>
Jeff,

"select * from ...." does not create a new table, but just a pointer to the original table. If you "use in" the source table alias, but the cursor is still open, VFP keeps the source table open. The work-around that I have used is to add a dummy field to the select:
"select *,"*" as junq from thetable into cursor seeagain".

Hope this helps

David Bar-Yakov
davidby@telaviv.ndsoft.com