Article View: borland.public.cppbuilder.database.multi-tier
Article #656Re: How to fetch data from server?
From: Danny Wang
Date: Mon, 04 Jun 2001 21:19
Date: Mon, 04 Jun 2001 21:19
38 lines
2158 bytes
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!dnewsReferences:
<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