Article View: comp.lang.pascal.delphi.databases
Article #24Please Help
From: abaab hichem
Date: Wed, 21 Apr 1999 00:00
Date: Wed, 21 Apr 1999 00:00
27 lines
1771 bytes
1771 bytes
Hi,
I made an application in delphi 4 Client Server that uses lots of
databases , I want to use a heterogenous queries, but when I running my
application I get the error message " No such table or correlation
name" here's my code :
FormDatacpl.sqlcontactclient.Close;
FormDatacpl.sqlcontactclient.SQL.clear;
FormDatacpl.sqlcontactclient.SQL.Add('SELECT
Dbo_contactclient.REFCLIENT, Dbo_contactclient.STATUT,
Dbo_contactclient.NOM');
FormDatacpl.sqlcontactclient.SQL.Add('dbo_contactclient.PRENOM,
Dbo_contactclient.DATENAISS, Dbo_contactclient.LANGUE,
Dbo_contactclient.FONCTION, Dbo_contactclient.TEL');
FormDatacpl.sqlcontactclient.SQL.Add ('Dbo_contactclient.GSM,
Dbo_contactclient.FAX');
FormDatacpl.sqlcontactclient.SQL.Add(' Dbo_contactclient.E_MAIL,
Dbo_contactclient.NOTE');
FormDatacpl.sqlcontactclient.SQL.Add('FROM
":BASE_CPL:dbo.CONTACTCLIENT" ');
FormDatacpl.sqlcontactclient.SQL.Add('JOIN ":cubic3:Scli01" ');
FormDatacpl.sqlcontactclient.SQL.Add ('ON (Dbo_contactclient.REFCLIENT
= Scli01.C_NUMERO)');
FormDatacpl.sqlcontactclient.ExecSQL;
FormDatacpl.sqlcontactclient.open;
Thank in advance!
Technical Details
Message-ID:
<371DCF43.698E0A73@mail.switchon.be>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: ffff5,62dd99384bc7a75a,start X-Google-Attributes: gidffff5,public X-Google-Thread: 115d96,62dd99384bc7a75a,start X-Google-Attributes: gid115d96,public From: abaab hichem <abaab.hichem@mail.switchon.be> Subject: Please Help Date: 1999/04/21 Message-ID: <371DCF43.698E0A73@mail.switchon.be> X-Deja-AN: 469123016 Content-Transfer-Encoding: 7bit X-Accept-Language: en Content-Type: text/plain; charset=us-ascii Organization: EUnet Belgium, Leuven, Belgium Mime-Version: 1.0 Newsgroups: comp.lang.pascal.delphi.databases,borland.public.delphi.database