Record changed by another user

Azz1 2000-04-10 10:41:00

客户端 ClientdataSet1.ApplyUpdate(0) , 应用服务器上对应为master/detailed Query, ReconcileError 提示 "Record changed by another user". 但实际上只有一个用户在使用数据库.

...全文

225 4 打赏收藏转发到动态举报

写回复

4 条回复

切换为时间正序

请发表友善的回复…

发表回复

Muf 2001-05-26

打赏
举报

回复

这不是解决之道，难道非要改ResolveToDataSet属性不可吗？

ResolveToDataSet属性为True时，允许Master/Detail结构中的Detail表无需填写主键。

是Delphi的BUG吗？

sadpacific 2000-04-11

打赏
举报

回复

你用的是Oracle数据库吗？
造成这种问题的原因很简单：Update之后没有MergeChangeLog。

fyje 2000-04-11

打赏
举报

回复

主、细表中的数据在更新之前被其它程序修改。

Azz1 2000-04-11

打赏
举报

回复

informix 数据库, 问题已解决, 方法是将应用服务器上相应 DataSetProvider 的 ResolveToDataSet属性置为False

谢谢

Delphi 7.1 Update Release Notes=======================================================This file contains important supplemental and late-breakinginformation that may not appear in the main productdocumentation, and supersedes information contained in otherdocuments, including previously installed release notes.Borland recommends that you read this file in its entirety.NOTE: If you are updating a localized version of Delphi 7, visit the Borland Registered User web site to obtain a localized readme file that may contain important late- breaking information not included in this readme file.IMPORTANT: Delphi must be closed before installing this update. =====================================================CONTENTS * INSTALLING THIS UPDATE * UPDATING LOCALIZED VERSIONS OF DELPHI 7 * KNOWN ISSUES * ISSUES ADDRESSED BY THIS UPDATE - IDE - CORE DATABASE - DATASNAP - DBGO (ADO COMPONENTS) - dbExpress - dbExpress COMPONENTS AND DB VCL - dbExpress CORE DRIVER AND METADATA - dbExpress VENDOR ISSUES - dbExpress CERTIFICATION - WEB SNAP - ACTIVEX - COMPILER - RTL - VCL - THIRD PARTY - BOLD FOR DELPHI * VERIFYING THAT THE UPDATE WAS SUCCESSFUL * FILES INSTALLED BY THIS UPDATE =======================================================INSTALLING THIS UPDATE* This update can not be applied to Delphi 7 Architect Trial version. * This update can not be removed after it is installed.* You will need the original Delphi 7 installation CD available to install this update.* To install this update from the CD, insert the CD, and launch the d7_ent_upd1.exe file appropriate for your locale.* To install this update from the Web, double-click the self-executing installation file and follow the prompts. * The Delphi 7 documentation PDF files are available on the update CD.========================================================UPDATING LOCALIZED VERSIONS OF DELPHI 7* This update can be applied only to the English version of Delphi 7. There are separate updates for the German, French and Japanese ver

对于浮点数可能会导致更新ClientDataset出现"Record Changed by Another user"错误，这是由于float截断导致的。解决方法：将对应的DatasetProvider的Updatemode=whereKeyOnly.将联系的query字段PKNO的providerFlag设置为pfInkey.

数据源的获取函数Table高级函数List列表高级函数Record记录高级函数日期函数时间函数正则表达式应用网页抓取函数

ClientDataSet提交时出现"Record not found or changed by another user"错误提示分析原因可能是找找不到更新数据，从网上搜索到大致原因有一下几个方面：1、没有主键2、某些字段不能识别某些提供解决方案也无非是设置DSP的UpdateMode属性，去掉字段的一些默认值这些问题，我仔细检查了一下，感觉不可能存在，仔细分析原因：我更新记录是分两种方式一种

'record not found or changed by another user'，这个错误是我在做项目时，遇到的问题，找了一些参考才解决。如下：所用的控件有:TDataSetProvider，TADOQuery，TClientDataSet 1.当 DataSetProvider.UpdateMode=upWhereAll 时

5,388

社区成员

262,730

社区内容

发帖

与我相关

我的任务

社区管理员

加入社区

近7日
近30日
至今

加载中

查看更多榜单

社区公告

暂无公告

试试用AI创作助手写篇文章吧

+ 用AI写文章