Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Can't remove non-existant table
Message
 
 
To
07/11/2003 16:43:41
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00847802
Message ID:
00847838
Views:
22
Hi Trey

>Make him clean it up

You're right, that is the obvious answer!! :)

>or
>
>You could hack the dbc - BACKUP FIRST
>[note: this only works if
>1. the table names in the database are the same as the file name
>2. the tables are in the same directory [or at least the search path] as the database
>
>
Close Databases All
>Open Database yourdatabase Shared
>Cd (JustPath(DBC()))
>Select objectid From DBC() ;
>   where objecttype="Table" ;
>   and !File(ForceExt(Alltrim(objectname),"dbf")) ;
>   into Cursor cuNotFound
>Delete From DBC() ;
>   where objectid In (Select objectid From cuNotFound) ;
>   or parentid In (Select objectid From cuNotFound)
>** and if you get exclusive access...
>Close Databases All
>Open Database yourdatabase Exclusive
>Pack Data
>
Might have to go with this, thanks a lot for the sample!

jfh
Previous
Reply
Map
View

Click here to load this message in the networking platform