FoxPro

[Stranger]

After importing FoxPro databases, how do I figure out there relationships? I don't see any unique keys.

 

[John Vinson]

After importing FoxPro databases, how do I figure out there relationships? I don't see any unique keys.

Depending on how the FoxPro developer set things up, there might not
BE any unique keys - they might have handled relational integrity
programmatically rather than in the table structure. Can you open the
database in FoxPro? What version - Visual FoxPro, or good old FoxPro
2.0?

There's still a fairly active FoxPro/VFP group at the CompuServe forum
in my .sig if you'ld like to drop by for some advice about converting
or analyzing the database. You'll need an ID and password, but it's
free.

 

[Stranger]

I do have VF 6.0. I can open the tables there but I am not familiar with
FoxPro. I can what fields are indexed but nothing that indicates a key
field(s). Do you have to belong to CompuServe to get there?

 

[John Vinson]

I do have VF 6.0. I can open the tables there but I am not familiar with
FoxPro. I can what fields are indexed but nothing that indicates a key
field(s). Do you have to belong to CompuServe to get there?

No; if you connect to the link in my .sig, you'll get a logon screen -
BUT if you scroll down you'll find an option to create a new ID and
password. There is no charge (if you're connecting from the United
States, Europe has a different division of CompuServe which does
charge :-{( ).

Pick an ID with a mixture of letters and numbers - it uses the AOL/AOL
Instant Messenger namespace so all the simple names have already been
taken.

Another site where a lot of FoxGang members hang out is on
http://www.universalthread.com.