[三层(midas)] Record not found or changed by another user

kwer 2008-05-29 01:10:10
问题应该是由于MSSQL某些字段因为是default的，在修改或插入时触发引起的
...全文
145 3 打赏 收藏 转发到动态 举报
写回复
用AI写文章
3 条回复
切换为时间正序
请发表友善的回复…
发表回复
kugoo_2006 2008-06-04
  • 打赏
  • 举报
 回复
数据库中设置一个主键试试
kwer 2008-05-29
  • 打赏
  • 举报
 回复
确认没有第二个连接,但也许是 Record not found 原因

用事件探查器发现自动产生UPDATE语句的where条件有些奇怪，尽然有 xx is null
僵哥 2008-05-29
  • 打赏
  • 举报
 回复
[Quote=引用楼主 kwer 的帖子:]
问题应该是由于MSSQL某些字段因为是default的，在修改或插入时触发引起的
[/Quote]
理由呢？你确认没有第二个连接对同一条记录比你先更新？
Delphi7.1 Update
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
"Record not found or changed by another user"
原因： Clientdataset提交数据时服务器端比对提交数据Delta中的原始数据,如果比对数据不符则报告上述错误,一般发生在插入操作后更新,对于单表发生错误原因如下: 1 数据库有自增长字段.测试发现ADO可以在插入数据后自动刷新自增长字段值,在afterupdaterecord事件中加入下面语句可以在更新后同步刷新clientdataset if (updatekind=ukinsert)...
问题-"Record not found or changed by another user"
回答1：===============================================================问题：clientdataset“Record not found or changed by another user”unable to find record no key specified原因：Clientdataset提交数据时服务器端比对提交数据Del...
clientdataset“Record not found or changed by another user”问题
Clientdataset提交数据时服务器端比对提交数据Delta中的原始数据,如果比对数据不符则报告上述错误,一般发生在插入操作后更新,对于单表发生错误原因如下:1 数据库有自增长字段.测试发现ADO可以在插入数据后自动刷新自增长字段值,在afterupdaterecord事件中加入下面语句可以在更新后同步刷新clientdataset  if (updatekind=ukinsert) the
诺信手机销售软件(V8.4)审核过账出错 提示：审核失败，请稍后再试111！
诺信手机销售软件(V8.4) 错误一：诺信软件审核过账出错提示：审核失败，请稍后再试111！ 检查加密狗是否插好，或者把加密狗换一个USB插口 错误二：诺信软件审核过账出错提示：Record not found or changed by another user 处理方法：midas.dll冲突导致，搜索一下midas.dll，把其它不是诺信文件夹下的删除掉 错误三：诺信软件该商品资料可能被其它用户修改，系统将重新读出最新数据！ Record not found or changed by ..
数据库相关

2,498

社区成员

88,445

社区内容

发帖
与我相关
我的任务
社区描述
Delphi 数据库相关
社区管理员
  • 数据库相关社区
加入社区
  • 近7日
  • 近30日
  • 至今

加载中

查看更多榜单
社区公告
暂无公告

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

+ 用AI写文章