Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to delete a nameless table
Message
From
29/11/1999 12:49:49
 
 
To
29/11/1999 11:21:27
General information
Forum:
Visual FoxPro
Category:
Stonefield
Miscellaneous
Thread ID:
00296332
Message ID:
00296433
Views:
20
Hi Doug,
Thank you, that did it, sort of. I get rid of the unnamed table, but the dbc inconsistecy error is still there. I would like tocreate the whole enchilada from sdt. Can I do that? delete all exept sdt tables and run oMeta.oSDTMgr.Update('ALL')?
Would that work??


Next I would like to see sdt explorer without the treeview. A replacement of modi stru of sorts. Like: oMeta.oSDTMgr.ModiStru('mytable'). It is a real pain to bring up SDT (it takes up to 5 minutes on my 3000 mHz system so I can add a logical field). Having used the treeview and abandoned it for the slowness, I woud rather have a grid instead with just the tables and views in it (no fields)


Peter


>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
Peter Cortiel
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform