Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>>>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only