🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

TProvider - TClientDataSet database update problem

#1358
From: Walter Sciotti
Date: Mon, 06 Dec 1999 00:00
17 lines
1328 bytes
I have a TQuery on my server with an associated TUpdateSQL object to handle
updates to existing records. This exported via a TProvider. A TClientDataSet
on the client connects to it.

The problem is this: I can read the data and display it, no problem. But
when I make a change to the data and call ApplyUpdates(-1) on the
TClientDataSet I get an exception: "Record changed by another user." But it
hasn't been changed and the record remains unchanged in the database.

Other times no exception is thrown, but the data is still unchanged. And,
rarely, the data actually gets updated without any exception being thrown.

There is nothing wrong with the SQL statements involved. Other TQuery's,
etc., on the same interface on the same server work fine: they fetch and
update data just like they're supposed to.

Any ideas?
Technical Details
Message-ID: <82g9ro$25o19@forums.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,dc09a63e5c46859c,start
X-Google-Attributes: gidfcd2b,public
From: "Walter Sciotti" <wsciotti@interlog.com>
Subject: TProvider - TClientDataSet database update problem
Date: 1999/12/06
Message-ID: <82g9ro$25o19@forums.borland.com>
X-Deja-AN: 557233881
Organization: Another Netscape Collabra Server User
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Newsgroups: borland.public.cppbuilder.database.multi-tier