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 ?
LinkExternalTable functionality
Re: LinkExternalTable functionality
Hello,
Unfortunately, there is no method in UniDAC similar to LinkExternalTable
Unfortunately, there is no method in UniDAC similar to LinkExternalTable
Re: LinkExternalTable functionality
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.
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.
Re: LinkExternalTable functionality
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
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