数据窗口多次保存有时失败的问题

为什么数据窗口多次保存时有时候会失败？ 问题点数：20、回复次数：7Top

1 楼angloy（烂柯遗梦）回复于 2005-06-05 00:48:19 得分 0

提示出什么错？请说详细点。Top

2 楼weiqiangfei（小笑）回复于 2005-06-05 16:21:22 得分 0

Row   changed   between   retrieve   and   update.  
   
  No   changes   made   to   database.  
   
  UPDATE   "SCHEDULE"   SET   "PLAN_ELIGIBLE_NUM"   =   :1   WHERE   "JOINTID"   =   :2   AND   "SCHEDULE_CODE"   =   :3   AND   "ASSEMBLY_CODE"   =   :4   AND   "PLAN_START_DATE"   =   :5   AND   "PLAN_COMPLETE_DATE"   =   :6   AND   "PLAN_DATE"   =   :7   AND   "CAST_RATIO"   =   :8   AND   "PLAN_NUM"   =   :9   AND   "PLAN_ELIGIBLE_NUM"   =   :10   AND   "COMMPLETED_NUM"   =   :11   AND   "UNCOMPLETE_NUM"   =   :12   AND   "ISSUED_NUM"   =   :13   AND   "ATTRIBUTE1"   =   :14   AND   "ATTRIBUTE2"   IS   NULL   AND   "ATTRIBUTE3"   =   :15   AND   "ATTRIBUTE4"   =   :16   AND   "ATTRIBUTE5"   IS   NULL   AND   "ADD_UP_CAST_NUM"   =   :17   AND   "CAST_COMPLETE_FLAG"   =   :18   AND   "PRODUCT_PLAN_CODE"   IS   NULL   AND   "ACTUAL_COMPLETE_FLAG"   =   :19   AND   "ORDERCODE"   =   :20   AND   "CREATOR"   =   :21   AND   "CREATETIME"   =   :22   AND   "CHECKER"   IS   NULL   AND   "CHECKTIME"   IS   NULL   AND   "PRI"   =   :23   AND   "SHOP_NUM"   IS   NULL   AND   "REMARK"   =   :24   AND   "CHECKFLAG"   =   :25   AND   "PUTOUTFLAG"   =   :26   AND   "SHOP_NAME"   =   :27   AND   "ASSEMBLY_CLASS"   =   :28   AND   "SHOP_CODE"   =   :29   AND   "YEARMONTH"   =   :30   AND   "TYPE"   =   :31   AND   "SPEC"   =   :32   AND   "CUSTOMERNAME"   =   :33   AND   "SALEBRANCH"   =   :34   AND   "TECHPLANCODE"   IS   NULL   AND   "UNIT"   =   :35   AND   "CHARACTER"   =   :36   AND   "MULTIPLE"   =   :37   AND   "STAT_DATE"   =   :38   AND   "PLAN_START_WEEK"   =   :39   AND   "RECEIVE_FLAG"   =   :40   AND   "RECEIVE_BY"   IS   NULL   AND   "RECEIVE_TIME"   IS   NULL   AND   "INWAREHOUSE_LATELY"   IS   NULL   AND   "SCHEDULE_TYPE"   =   :41   AND   "INTENDING_INWARENUM"   =   :42   AND   "VOLTAGE"   =   :43   AND   "PRECISION"   =   :44   AND   "MODIFIED_BY"   =   :45   AND   "MODIFIED_TIME"   =   :46Top

3 楼njupt_zhb（攒钱买飞机）回复于 2005-06-05 16:45:21 得分 20

 
  数据窗口画板里,菜单rows->update   properties...:  
  where   clause   for   update/delete   选择key   columnsTop

4 楼weiqiangfei（小笑）回复于 2005-06-05 17:19:35 得分 0

有什么区别吗？Top

5 楼njupt_zhb（攒钱买飞机）回复于 2005-06-05 17:25:20 得分 0

以主键作为update语句的where条件,不会产生"Row   changed   between   retrieve   and   update."错误Top

6 楼weiqiangfei（小笑）回复于 2005-06-05 17:28:52 得分 0

那key   and   Updateable   Columns   是怎么更新数据库的，PB为什么会默认？先谢谢了。Top

7 楼njupt_zhb（攒钱买飞机）回复于 2005-06-05 17:48:24 得分 0

在pb帮助中搜索打开"Specify   Update   Properties   dialog   box",  
  点击最下面"for   more   information"下面的图标....Top

相关问题

• code
• date
• null
• plan
• num
• attribute
• cast
• complete
• update
• shop

• 帖主：weiqiangfei
• njupt_zhb

• PowerBuilder类图书
• PowerBuilder类源码下载