Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why would this query return duplicates
Message
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Why would this query return duplicates
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01376377
Message ID:
01376377
Views:
42
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
Next
Reply
Map
View

Click here to load this message in the networking platform