🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: comp.lang.pascal.delphi.databases
Article #24

Please Help

#24
From: abaab hichem
Date: Wed, 21 Apr 1999 00:00
27 lines
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-mail

Show 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