Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Primary Key
Message
From
14/12/2002 15:39:50
Alex Feldstein
Florida, United States
 
 
To
14/12/2002 14:59:49
John Weller
Wessex Computer Solutions
Devizes, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Primary Key
Miscellaneous
Thread ID:
00733075
Message ID:
00733079
Views:
38
>Does anyone know of a method to identify the primary key for a table programmatically?
>
>John Weller

In VFP you can do it with DBGetProp() like this:
OPEN DATABASE (HOME(2)+"data\testdata")
USE (HOME(2)+"data\customer")
? DBGETPROP("customer","table","PRIMARYKEY")
HTH


Alex Feldstein, MCP, Microsoft MVP
VFP Tips: English - Spanish
Website - Blog - Photo Gallery


"Once again, we come to the Holiday Season, a deeply religious time that each of us observes, in his own way, by going to the mall of his choice." -- Dave Barry
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform