Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Cannot add table
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00675033
Message ID:
00675040
Vues:
12
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?
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform