Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Checking if a table is free
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00198666
Message ID:
00198718
Vues:
20
>>Is there a way you can check if a table isn't part of a database? I move a lot of tables around to get information from our remote locations to our web server. Some of these tables originally belonged to a database, so I need some way of checking that before I try to FREE them. If I knew this was going to work perfectly everytime, I could just code for the tables that I know were part of a database. But, things being as they are, I'm being cautious.
>>
>
>Aside from munging with the headers (the exact formats are documented very clearly in the VFP docs, so you could do this pretty easily with low-level file I/O), if you know the name of the database that the table might be a member of, you could use the INDBC() function.
>
>You could also use COPY TO or a SQL Select to pull the data from the original table into a fresh, known-free table.
>
>>Thanks,

OK, thanks. I think I'll make some adjustments to a class I already have for changing the backlink.

-Paul
-Paul

RCS Solutions, Inc.
Blog
Twitter
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform