Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Can't remove non-existant table
Message
 
À
07/11/2003 16:43:41
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00847802
Message ID:
00847838
Vues:
23
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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform