>>>>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?
>>>
>>>Ken,
>>>
>>>Define what Stops means. An error?
>>>
>>>Regards, Renoir
>>
>>My apologies. The program "hangs". When stepping through code the program hits the USE IN TABLEA line and does not move for "minutes". That is it doesn;t move to the next statement in the code and I have to dump (ctrl-alt-del) the program.
>
>Well, there is nothing wrong with your command structure or syntax. I would look towards the table. What happens when you try to use the table from the command window? Is there anything strange about the data? Are you hitting against a SQL backend? So many questions... :)
>
>Renoir
Thanks for the input. Please see my reply to Daniel Rouleau.