Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Determine Key Field for View
Message
From
12/01/2006 16:58:29
Scott Butts
Ims Specialty Services
Twin Falls, Idaho, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
Determine Key Field for View
Environment versions
Visual FoxPro:
VFP 8 SP1
Miscellaneous
Thread ID:
01086346
Message ID:
01086346
Views:
72
I am trying to dynamically create a DBC and add a view for each of the tables that are found in a SQLServer database. Everything seems to be working find using the SQLTables() and SQLColumns() functions. I just have one problem, how do I determine what they key field is programmatically. The view designer can figure it out, so there should be a way to do it thru code.... right?

Any help would be greatly appreciated.

Scott
Next
Reply
Map
View

Click here to load this message in the networking platform