Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot add table
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00675033
Message ID:
00675040
Views:
14
Hi Lawrence,

The reason you can't add the table is that the table's header contains the name of a database that it (supposedly) belongs to.

If you USE the table and DISPLAY MEMORY, when it lists the table, does it also show it as part of a DBC?

If so, AND if the database container no longer exists, you can issue the
FREE TABLE MyTable
command to release the link to the non-existent DBC. Be advised: once you do this, you lose any long fieldnames.

However, if the database container still exists, and you don't open the DBC first, you risk corrupting the DBC permanently. In this case, you *MUST* open the database container and issue the
REMOVE TABLE MyTable
command to remove the link to the existing DBC. Be advised: when you remove a table, you also lose any indexes, default values, validation rules, etc. that are associated with the table while inside the DBC.

HTH.

>I have a table that I'm trying to add to my database. Whenever I try, I get a message saying that I can't add the table because it belongs to the database. Can anyone tell me how to correct this problem?
>
>Lawrence
Evan Pauley, MCP
Positronic Technology Systems LLC
Knoxville, TN

If a vegetarian eats vegetables, what does a humanitarian eat?
Previous
Reply
Map
View

Click here to load this message in the networking platform