• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 245
  • Last Modified:

Connect FoxPro from two folders by ADO

Dear advisor !

I use Delphi 2005

I connect FoxPro Table by using ADO. Because those tables are exised on two folders. So how to write a query to retrieve data from two tables existing on two folders.

when setup paramater for ADO, they only permit to choice one folder

thank for all consider
0
namcit99
Asked:
namcit99
  • 2
1 Solution
 
VoodoomanCommented:

Hi

You can attach them to an Access Database, you can then query/join the tables and update them seperately as MSAccess will do the work.

Open MSAccess (you need MSOffuce to do this) File/GetExternalData/LinkTables.

One the tables are linked you can open the Access Database from Delphi and do what you like with the tables.

You can of course attach/link the tables in code if you want the whole thing to be dynamic.

I can't help with the code in Delphi, but I have often done this with Visual Basic without problem.

I don't use ADO with Delphi as I prefer EasyTable, Accuracer and DBISAM.

Voodooman
0
 
namcit99Author Commented:

i should use FoxPro from two folders. No change
0
 
VoodoomanCommented:

How namcit99 ?

Each folder is treated as a seperate database (isn't it?), requiring two connections.  You cannot join tables on different connections (if you can I would be pleased to here how).

Regards

Voodooman
0
 
BlackTigerXCommented:
that's right, if you only wanted to use Foxpro, this is not possible, a workaround however is what Voodooman suggested, you are still using the Foxpro tables, but you access them different, trhough MSAccess or any other application that lets you link external tables
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now