Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot close table
Message
From
25/06/2001 14:12:22
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00523066
Message ID:
00523103
Views:
18
>>>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
Map
View

Click here to load this message in the networking platform