Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Check for tag existance without opening the table
Message
De
22/12/2005 11:56:27
 
 
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
Visual FoxPro:
VFP 9
OS:
Windows XP SP2
Database:
Visual FoxPro
Divers
Thread ID:
01080193
Message ID:
01080213
Vues:
16
This message has been marked as the solution to the initial question of the thread.
>Hi everybody,
>
>Is there a way to test for tag existance just by opening database and not the table?
>
>Thanks.

dbc tables and tag repository:
CLOSE DATABASES ALL
USE HOME(2)+'Northwind\northwind.dbc' IN 0 ALIAS dbc NOUPDATE 

SELECT T.ObjectName table,I.ObjectName Tag  FROM dbc T JOIN dbc  I ON T.ObjectId = I.ParentId;
WHERE T.objecttype == 'Table' AND I.objecttype == 'Index'
Of course, the whole table/index files would be able not to exist or to be corrupt
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform