Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
IsFreeTable() Function, and Copy DBC Database
Message
 
 
To
27/09/2010 00:00:46
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Miscellaneous
Thread ID:
01482810
Message ID:
01482829
Views:
64
Hi All

For Q1 see http://www.berezniker.com/content/pages/visual-foxpro/check-if-table-part-dbc

>I'm writing a backup utility that will need to back up tables that may be in use by others, as well as DBC-related files that may also be in use by others.
>
>
>Question 1:
>
>Is there a way, before actually opening a table, to determine if it's a free table, or if it's part of a DBC database?
>
>One general approach is to:
>
>* Make sure there is no database open
>* Open the table
>* See if DBC() returns an empty string
>
>
>The table may be in use by someone else (non-exclusively), don't know if that would have any effect on LLFF-based approaches.
>
>
>Question 2:
>
>To copy an open DBC and related files, I'm planning to open it non-exclusively as a table, then use VFP COPY... or APPEND commands to build another one elsewhere.
>
>Although with all my applications the DBC resides in the same folder as its member tables, that may not always be the case. Are there any special considerations or gotchas regarding backlinks?
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform