MultiTier SQL query problem

Article View: borland.public.cppbuilder.database.multi-tier

Article #45

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#45

From: Claude
Date: Tue, 02 Mar 2004 16:10

7 lines
1307 bytes

I have a DELETE I am trying to execute via a SQLDataSet.
The DataSource used points to a DataSet with its RemoteServer set.
(The DataSource works fine with a dbgrid using both DCOM and sockets)
When I execute the CommandText (CommandType set to ctQuery), I
get an error - SQLConnection Property required for this operation.
Why is the SQLConnection Property required?
How do I make it a remote lookup?

Technical Details

Message-ID: <4044b1d5$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,d5055b93b823ef45,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2004-03-02 08:11:37 PST
Reply-To: "Claude" <claude@dev.scomage.com>
From: "Claude" <claude@dev.scomage.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: MultiTier SQL query problem
Date: Tue, 2 Mar 2004 11:10:28 -0500
Lines: 9
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: 68.39.101.128
Message-ID: <4044b1d5$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1078243797 68.39.101.128 (2 Mar 2004 08:09:57 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail