TQuery, ODBC and intra-database select

Article View: borland.public.delphi.database

Article #125

Back to borland.public.delphi.database Previous Next

#125

From: Rob Prop
Date: Sat, 06 Dec 2003 10:39

13 lines
1472 bytes

Hello,

I am trying to connect to an informix database through ODBC. This works fine
with a TQuery and TDatabase component. Now I want to selct some data from
anoyher database. This is done with the sql command: select * from
otherdb:sometable

However it looks that the TQuery component want to replave :sometable with a
variable. Is there a workaround possioble. (Using Delphi 5).

Thanx in advance,

    Rob Prop

Technical Details

Message-ID: <3fd1b033$0$206$e4fe514c@news.xs4all.nl>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fr.ip.ndsoftware.net!npeer.de.kpn-eurorings.net!news.cambrium.nl!news.cambrium.nl!news.cambrium.nl!news2.euro.net!194.109.133.3.MISMATCH!binary.news.xs4all.nl!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 115d96,6c1c05554fe8486b,start
X-Google-Attributes: gid115d96,public
X-Google-ArrivalTime: 2003-12-06 02:32:20 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!newsfeed.freenet.de!fr.ip.ndsoftware.net!npeer.de.kpn-eurorings.net!news.cambrium.nl!news.cambrium.nl!news.cambrium.nl!news2.euro.net!194.109.133.3.MISMATCH!binary.news.xs4all.nl!not-for-mail
From: "Rob Prop" <rprop@xs4all.nl>
Newsgroups: borland.public.delphi.database
Subject: TQuery, ODBC and intra-database select
Date: Sat, 6 Dec 2003 11:39:26 +0100
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Lines: 15
Message-ID: <3fd1b033$0$206$e4fe514c@news.xs4all.nl>
NNTP-Posting-Date: 06 Dec 2003 11:32:19 CET
NNTP-Posting-Host: 80.126.115.183
X-Trace: 1070706739 news.xs4all.nl 206 [::ffff:80.126.115.183]:35127
X-Complaints-To: abuse@xs4all.nl