Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking if a table is free
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00198666
Message ID:
00198718
Views:
19
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform