>>I am using the following to close a data table
>>
>>IF USED("TABLEA")
>> USE IN TABLEA
>>ENDIF
>>
>>
>>When the program gets to the line USE IN TABLEA, it stops. The table is a member of DBC, contains no memo fields , and four indexes(no compound indexes).
>>
>>What could cause this?
>
>This works for me:
>
>IF USED('tablea')
>SELECT tablea && select the open table
>use && closes the table in the current work area
>
> otherwise I think you are using a second instant of the table and then closing the second instance, leaving the original one still open.

Douglas,

The syntax show is a valid one, but you can simplify your life doing all closing in just one line (this is that I use nowdays after picking this advice some time ago from here (from Alex Feldstein (if I recall correctly)):

use in select('TableA')

No need for if endif...