Article View: borland.public.cppbuilder.database.multi-tier
Article #655Re: How to fetch data from server?
From: Danny Wang
Date: Mon, 04 Jun 2001 20:55
Date: Mon, 04 Jun 2001 20:55
27 lines
1836 bytes
1836 bytes
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:
<3B1BF5D0.4040204@bbm.ca>Path:
arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!dnewsReferences:
<3B1BEB40.8040902@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:11:15 PST Message-ID: <3B1BF5D0.4040204@bbm.ca> Date: Mon, 04 Jun 2001 13:55:44 -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> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit NNTP-Posting-Host: 206.116.211.2 X-Trace: dnews 991677345 206.116.211.2 (4 Jun 2001 10:55:45 -0700) Lines: 29 Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!isdnet!skynet.be!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews