🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: be.comp.programming
Article #11940

Delphi multi tier problem

#11940
From: Gargoyle
Date: Wed, 02 Jan 2002 14:09
34 lines
2102 bytes
Hi,

I am using as server a remote data module which holds a TIBStoredProc
connected to a TDataSetProvider.On the clients side I am using a
TClientDataSet conected to the TDataSetProvider on the server (so far so
good, i think). There is also a TDatasource connected to the TClientDataset.
Now for my problem:

On a simple form I am using a 2 TDBLoookupComboBoxes to get some info. I
want to sent 2 different parameters(KL_ID and KLAD_ID) to the TIBStoredProc
and get other data back. But I get nothing back.

With DMClient do
    begin
    With CDSOphalenKlAd do
        begin
        Params.ParamByName('KLAD_ID').Value := KL_ID;
        Params.ParamByName('Kl_ID').Value := KLAD_ID;
        Execute;
    end;
    With CDSOphalenBest do
        begin
        Params.ParamByName('KL_ID').Value := DBLookupKlant.KeyValue;
        Params.ParamByName('KLAD_ID').Value := DBLookupKLAD.KeyValue;
        execute;
    end;
end;

What do I have to do to get the corresponding data back from my server?
I want to fill this data into a dbGrid.
What do I do?

regards,
F.
Technical Details
Message-ID: <ewEY7.5124$mE6.1447467056@hestia.telenet-ops.be>
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!opentransit.net!newsfeeds.belnet.be!news.belnet.be!ossa.telenet-ops.be!hestia.telenet-ops.be.POSTED!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcea4,a9f87552813810eb,start
X-Google-Attributes: gidfcea4,public
X-Google-ArrivalTime: 2002-01-02 06:09:25 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!opentransit.net!newsfeeds.belnet.be!news.belnet.be!ossa.telenet-ops.be!hestia.telenet-ops.be.POSTED!not-for-mail
From: "Gargoyle" <Gargoyle@NOSPAMpandora.be>
Newsgroups: be.comp.programming
Subject: Delphi multi tier problem
Lines: 38
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2600.0000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000
Message-ID: <ewEY7.5124$mE6.1447467056@hestia.telenet-ops.be>
Date: Wed, 02 Jan 2002 14:09:14 GMT
NNTP-Posting-Host: 213.118.40.29
X-Complaints-To: abuse@pandora.be
X-Trace: hestia.telenet-ops.be 1009980554 213.118.40.29 (Wed, 02 Jan 2002 15:09:14 CET)
NNTP-Posting-Date: Wed, 02 Jan 2002 15:09:14 CET
Organization: Telenet Internet