Article View: borland.public.cppbuilder.database.multi-tier
Article #847Updating a Recordset
From: Mike
Date: Tue, 23 Jan 2001 16:33
Date: Tue, 23 Jan 2001 16:33
8 lines
1591 bytes
1591 bytes
Ok, I need to backup a step or two. I am trying to make changes to a record set in a multitier database configuration. The changes seem to post on the first time out, but subsequent attempts fail with "ClientDataSet: Must apply updates before refreshing data." It doesn't matter what I do, the changes seem to get stuck in the client data set. My environment is Windows 2000, InterBase 6.0, C++Builder Enterprise. I am using the typical 3-tier configuration with an IBTransaction, IBDatabase, IBUpdateSQL, IBQuery, and IBDataSetProvider in the middle tier. The client uses a SocketConnection, a ClientDataSet, and a DataSource. I am feeding a simple DBGrid in conjunction with a DBNavigator. I have a sample project setup with both client and server if someone would care to take a look. I'd greatly appreciate it. Thanks.
Technical Details
Message-ID:
<3a6db252$1_1@dnews>Path:
arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!207.105.83.65Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,48f222a4e60f3490,start X-Google-Attributes: gidfcd2b,public X-Google-ArrivalTime: 2001-01-23 08:40:16 PST From: "Mike" <mike.powell@transcore.com> Sender: "Mike" <mike.powell@transcore.com> Reply-To: "Mike" <mike.powell@transcore.com> Subject: Updating a Recordset Newsgroups: borland.public.cppbuilder.database.multi-tier X-User-Info: 198.59.170.33 198.59.170.33 NNTP-Posting-Host: 207.105.83.65 Message-ID: <3a6db252$1_1@dnews> Date: 23 Jan 2001 08:33:22 -0800 X-Trace: 23 Jan 2001 08:33:22 -0800, 207.105.83.65 Lines: 9 Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-02!supernews.com!isdnet!newsfeeds.belnet.be!naxos.belnet.be!news.belnet.be!bornews.borland.com!dnews!207.105.83.65