🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: How to fetch data from server?

#656
From: Danny Wang
Date: Mon, 04 Jun 2001 21:19
38 lines
2158 bytes
And I found the second problem can be workaround by adding a line:

ClientDataModule->RspCD->Last();

on ClientSide before call RspCD->Refresh();
Anybody knows the reason?


Danny Wang wrote:

> Furthermore, my source code is here:
> //Client side:--------------
> if(!ClientDatamodule->RspCD->Active )
>       ClientDatamodule->RspCD->Active = true;
> // do some works on server side, include filter the data
> TempInterface.SelFilterRsp(CellWStr.c_bstr(),AudWStr.c_bstr(),WeekWStr.c_bstr(),STWStr.c_bstr(),&RspCnt); 
> 
> ClientDatamodule->RspCD->Refresh();//get the newest data
> 
> //Server side:---------
> m_DataModule->RspQry->Close();
>     m_DataModule->RspQry->Filtered = false;
>     m_DataModule->RspQry->SQL->Clear();
>     m_DataModule->RspQry->SQL->Add(sql+wheresql);
>     m_DataModule->RspQry->Open();
>     if(...>0)
>     {
>         m_DataModule->RspQry->Filtered = true;
>         }
>     else
>         m_DataModule->RspQry->Filtered = false;
>     *RspCount = m_DataModule->RspQry->RecordCount;
>     return S_OK ;
> //Server side OnFilterRecord event:
> if(...)
>  Accept = true;
> else
>   Accept = false;
Technical Details
Message-ID: <3B1BFB5D.1080101@bbm.ca>
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews
References: <3B1BEB40.8040902@bbm.ca> <3B1BF5D0.4040204@bbm.ca>

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,c21d3c82d545c312
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-06-04 11:46:18 PST
Message-ID: <3B1BFB5D.1080101@bbm.ca>
Date: Mon, 04 Jun 2001 14:19:25 -0700
From: Danny Wang <dwang@bbm.ca>
Reply-To: dwang@bbm.ca
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; m18) Gecko/20001108 Netscape6/6.0
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: Re: How to fetch data from server?
References: <3B1BEB40.8040902@bbm.ca> <3B1BF5D0.4040204@bbm.ca>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 206.116.211.2
X-Trace: dnews 991678766 206.116.211.2 (4 Jun 2001 11:19:26 -0700)
Lines: 39
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!nntp-relay.ihug.net!ihug.co.nz!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!dnews