Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Given a field in data.dbc get the table
Message
From
01/10/2007 15:34:59
Aaron Hudon
British Columbia, Canada
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Given a field in data.dbc get the table
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows NT
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01257776
Message ID:
01257776
Views:
62
I have a scenario where I need to go to the DBC to find a field's table name. In this scenario, I am assured that field names in the DBC are unique.

Has anyone done this before, in an efficient SQL statement. I know this can be done with multiple passes on the DBC inspecting [objectname], [objecttype] and [parentid]...

Any help is most appreciated.
Next
Reply
Map
View

Click here to load this message in the networking platform