LinkExternalTable functionality

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bwilt
Posts: 15
Joined: Wed 07 Aug 2013 01:45

LinkExternalTable functionality

Post by bwilt » Wed 07 Aug 2013 20:29

Hello,
We have UniDac 5.0.1 which is connected to two MDB databases.

Previously we had used a LinkExternalTable() function to link into the main database a table from the second database.

We then performed a SELECT + INNER JOIN on the link table and external table.

Is there a way of performing this type of functionality ?

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: LinkExternalTable functionality

Post by AlexP » Thu 08 Aug 2013 10:10

Hello,

Unfortunately, there is no method in UniDAC similar to LinkExternalTable

bwilt
Posts: 15
Joined: Wed 07 Aug 2013 01:45

Re: LinkExternalTable functionality

Post by bwilt » Thu 08 Aug 2013 21:04

Hi Alex,

So is it possible to load two database i.e. two UniConnection + UniTables.

Then do a INNER JOIN between these two database's and tables ?

Both tables have the same structure.

AlexP
Devart Team
Posts: 5530
Joined: Tue 10 Aug 2010 11:35

Re: LinkExternalTable functionality

Post by AlexP » Fri 09 Aug 2013 09:29

Hello,

You can add the needed table to the database as a Link Table by means of MS Access. After this, the table will be available in UniDAC

Post Reply