Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Why would this query return duplicates
Message
 
 
À
Tous
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Titre:
Why would this query return duplicates
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01376377
Message ID:
01376377
Vues:
44
Hi everybody,

I want to get all table names from my database starting with some prefix. I put code like this
SELECT ObjectName FROM DBC() WHERE ObjectType = 'Table' AND PROPER(ObjectName) = 'Something' ;
ORDER BY 1 ;
and it's returning multiple records for one table. Is it an indication that database container may be corrupted?

Thanks in advance.
If it's not broken, fix it until it is.


My Blog
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform