Re: FoxPro

From: John Vinson (jvinson_at_STOP_SPAM.WysardOfInfo.com)
Date: 05/25/04


Date: Mon, 24 May 2004 23:10:08 -0600

On 24 May 2004 20:13:10 -0500, "Stranger" <stranger@raex.com> wrote:

>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.

                  John W. Vinson[MVP]
    Come for live chats every Tuesday and Thursday
http://go.compuserve.com/msdevapps?loc=us&access=public



Relevant Pages

  • Re: Word mail merge with foxpro
    ... > I am trying to connect to a dbf fine not the database. ... >> I do not think you will be able to open a .dbc using ODBC by selecting ... >> using that approach (in the Select Data Source dialog, ... >>> Firstly the files of type drop down does not give a foxpro option. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: Access 2000 run-time error 80004005 - HELP
    ... try changing the column definition (make a backup of the ... > destination table is a linked table originating from a FoxPro v3 database. ... it appears MS is letting FoxPro die a slow death. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Access 2000 run-time error 80004005 - HELP
    ... You could get the VFPOLEDB driver instead. ... I think Acess 2000 can use an OLE DB connection - it least programmatically. ... > destination table is a linked table originating from a FoxPro v3 database. ...
    (microsoft.public.fox.programmer.exchange)
  • Re: Database Connection
    ... Database Software: FoxPro 7 ... I installed the VFPOLEDB.DLL for FoxPro 8. ... No error information available: REGDB_E_CLASSNOTREG. ... Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Need to open Visual Fox Pro 8 tables in VB6
    ... There are several formats of Visual FoxPro files. ... VFP6 and below are readable via ODBC. ... "database container". ... Data Sources. ...
    (microsoft.public.vb.database.dao)

Loading