 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Patrick
Guest
|
 Posted: Wed Oct 11, 2006 3:37 pm Post subject: How can I join DBF files located in different folders? |
 |
|
How can I join 2 DBF files located in different folders to make one query?
Ex: I want to join files: C:\ICDATA\Icitem.dbf AND C:\PEDATA\PEBMDT.dbf
My OLE DB Provider is Visual Foxpro (v6 free tables DBF).
If the files were in the same folder, the query would be:
Select Icitem.Item, Pebmdt.Bomno
From Icitem
Join Pebmdt On (Pebmdt.Bomno = Icitem.Item)
Where Pebmdt.Bomno = 'WIDGET1'
Order By Pebmdt.Bomno
I normally use TADOConnection.
TIA!--patrick |
|
| Back to top |
|
 |
Steve Zimmelman
Guest
|
| Posted: Wed Oct 11, 2006 7:09 pm Post subject: Re: How can I join DBF files located in different folders? |
|
|
You might be able to use something like this:
Select Icitem.Item, Pebmdt.Bomno
From [C:\ICDATA\Icitem.dbf] Icitem
Join [C:\PEDATA\PEBMDT.dbf] Pebmdt On (Pebmdt.Bomno = Icitem.Item)
Where Pebmdt.Bomno = 'WIDGET1'
Order By Pebmdt.Bomno
-Steve-
"Patrick" <pdohogne (AT) majorcustomcable (DOT) com> wrote in message
news:452cc964 (AT) newsgroups (DOT) borland.com...
| Quote: | How can I join 2 DBF files located in different folders to make one query?
Ex: I want to join files: C:\ICDATA\Icitem.dbf AND C:\PEDATA\PEBMDT.dbf
My OLE DB Provider is Visual Foxpro (v6 free tables DBF).
If the files were in the same folder, the query would be:
Select Icitem.Item, Pebmdt.Bomno
From Icitem
Join Pebmdt On (Pebmdt.Bomno = Icitem.Item)
Where Pebmdt.Bomno = 'WIDGET1'
Order By Pebmdt.Bomno
I normally use TADOConnection.
TIA!--patrick
|
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
