I.T. Discussion Community!
-Collapse +Expand
Delphi
Search Delphi Group:

Advanced
-Collapse +Expand Delphi To/From
To/FromCODEGuides
-Collapse +Expand Delphi Store
PRESTWOODSTORE

Prestwood eMagazine

February Edition
Subscribe now! It's Free!
Enter your email:

   ► KBProgrammingDelphi for W...Using Data   Print This     
  From the May 2012 Issue of Prestwood eMag
 
Delphi Using Data:
Heterogeneous Joins in Delphi
 
Posted 17 years ago on 8/21/2002 and updated 3/18/2003
Take Away: Heterogeneous Joins in Delphi: by Mike Benemelis. A heterogeneous join is when you join tables from two different SQL servers (or a server and a local table) within the same query. This short article will show you how to perform such queries using Delphi.

KB100009



The Delphi 1.0 Database Application Developer’s Guide for performing a Heterogeneous join is not quite correct. The following was provided (in part) by Borland Technical Support:

To perform a heterogeneous join do the following.

  1. For each server table, a connection must exist before the query is executed. A TDatabase can be used to establish the connection.
  2. The SQL statement must use real Alias names, as set up in the BDE config file, Not the Database Name properties from a Tdatabase component.
  3. The SQL syntax should be formatted as follows: a double quote, a colon, a real alias name, a colon, the table name, and a double quote. See the example below:
  4. Leave the DatabaseName Property of the TQuery blank.

For Example:

Select A.VENDORNO, B.VENDORNO
From ":DBDEMOS:VENDORS" A, ":IBLOCAL:VENDORS" B
where A.VENDORNO = B.VENDORNO

I performed a query similar to the one above, using tables in an Oracle and MS SQL database. Both databases are on a windows NT 4.0 OS. The performance seemed slow, possibly due to the BDE having to bring the data down locally and to data translations.


Comments

0 Comments.
Share a thought or comment...
 
Write a Comment...
...
Sign in...

If you are a member, Sign In. Or, you can Create a Free account now.


Anonymous Post (text-only, no HTML):

Enter your name and security key.

Your Name:
Security key = P1204A1
Enter key:
KB Post Contributed By Mike Prestwood:

Mike Prestwood is a drummer, an author, and creator of the PrestwoodBoards online community. He is the President & CEO of Prestwood IT Solutions. Prestwood IT provides Coding, Website, and Computer Tech services. Mike has authored 6 computer books and over 1,200 articles. As a drummer, he maintains play-drums.com and has authored 3 drum books. If you have a project you wish to discuss with Mike, you can send him a private message through his PrestwoodBoards home page or call him 9AM to 4PM PST at 916-726-5675 x205.

Visit Profile

 KB Article #100009 Counter
4131
Since 4/2/2008
-
   Contact Us!
 
PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

2,374 People Online Now!!  
Sign In to see who's online now!  Not a member? Join now. It's free!
Show more stats...


©1995-2019 PrestwoodBoards  [Security & Privacy]
Professional IT Services: Coding | Websites | Computer Tech