Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
IsFreeTable() Function, and Copy DBC Database
Message
 
 
À
27/09/2010 00:00:46
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Divers
Thread ID:
01482810
Message ID:
01482829
Vues:
63
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--
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform