Re: heterogenous SQL queries

Article View: borland.public.cppbuilder.database.ado

Article #2444

Back to borland.public.cppbuilder.database.ado Previous Next

#2444

From: Pavel Stejgerle
Date: Thu, 19 Jun 2003 10:43

13 lines
1303 bytes

> What are you mean about heterogenous SQL?

Here is an example of heterogenous sql query using BDE, one DB is Paradox
and one is Sybase:

"SELECT B.* FROM ":My_1stDB_BDE_Alias:TGObjLock" A,
":My_2ndDB_BDE_Alias:Benutzer" B

WHERE A.TGObjLock_ID=8813489330994 AND A.TURNKEY_ID=B.Benutzer_ID"



PS

Technical Details

Message-ID: <3ef1942d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

References: <3ef175c5$1@newsgroups.borland.com> <3ef18017@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,7637cac091d12d16
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-06-19 03:46:35 PST
From: "Pavel Stejgerle" <pavel.stejgerle@tribut.cz>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3ef175c5$1@newsgroups.borland.com> <3ef18017@newsgroups.borland.com>
Subject: Re: heterogenous SQL queries
Date: Thu, 19 Jun 2003 12:43:46 +0200
Lines: 15
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 62.168.57.86
Message-ID: <3ef1942d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1056019501 62.168.57.86 (19 Jun 2003 03:45:01 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-01!sn-xit-09!supernews.com!newshosting.com!news-xfer1.atl.newshosting.com!newsfeed.wirehub.nl!news.kweb.on.ca!KWeb!newsgroups.borland.com!not-for-mail

Reply to Parent Message