Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
How to delete a nameless table
Message
De
29/11/1999 11:21:27
 
 
À
29/11/1999 08:40:02
Information générale
Forum:
Visual FoxPro
Catégorie:
Stonefield
Divers
Thread ID:
00296332
Message ID:
00296380
Vues:
18
Hi Peter.

>I somehow (but don't know how) get a table without name into the dbc and into SDT. Now I cannot delete that sucker. If I delete the table the dbc won't open anymore with a dbc inconsistency error.
>the rename and delete options on the right click menu in sdt are greyed out!

Have you done a VALIDATE DATABASE RECOVER? I don't know if it'll catch blank table names or not. If not, I suggest opening the DBC as a table (USE (whatever).DBC), browsing it, and removing the record for the table (look for OBJECTTYPE = "Table" and OBJECTNAME is blank). Then close the table and VALIDATE DATABASE RECOVER to remove any objects (like fields) belonging to the table. Finally, in SDT, click on the Validate Meta Data button to update the meta data.

Doug
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform