Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Weird Problem with DBC/Table
Message
 
To
28/01/2004 12:48:01
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00871473
Message ID:
00871487
Views:
20
PACK DATABASE?

Another thing to try, though possibly scary. Free the tables that are having the problem and reassociate them with the proper database after pack and validate both DBC's. You'll lose any long names so you should DISPLAY DATABASE to print on the database before doing that.

Richard

>Yes, that works, but then it occurs again.
>
>>Have you tried to validate the database? (VALIDATE DATABASE RECOVER)
>>
>>Richard
>>
>>
>>
>>>I have a situation that I am hoping someone can answer or help me troubleshoot.
>>>
>>>I have two databases, DBC1 & DBC2 (they DO NOT contain any table names or structures that are similar)
>>>DBC1 has tables: T11, T12, T13, T14, T15
>>>DBC2 has tables: T21, T22, T23, T24, T25
>>>
>>>DBC2 is active DB
>>>I am in the database designer (modify data)
>>>I right click on T22 an click browse, and what comes up ... T14
>>>All the other tables in DBC2 are fine when I browse them except T22.
>>>
>>>I checked the DBC with the use command and everything looks okay.
>>>
>>>Any ideas (or ibuprofen)?
State of Florida, DCF
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform