Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Locating all instances of a field
Message
 
To
28/06/2016 15:10:37
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01637786
Message ID:
01637796
Views:
66
As per Naomi's second suggestion, simply replace DatabaseName (lines 2 and 5) and Desired_FieldName (line 6) in the following query:

SELECT ObjectName AS TableName ;
FROM DatabaseName ;
WHERE ObjectID IN ( ;
SELECT ParentID ;
FROM DatabaseName ;
WHERE ObjectType = "Field" AND ObjectName = 'Desired_FieldName') ;
ORDER BY TableName

Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform