| 问题现象： | 821升级到870，基础档案的客户档案里，进入修改任意资料保存后该客户的银行资料就消失不见了 |
| 问题原因： | 由于升级过程中导致CustomerBank表中记录丢失造成，先将821数据库里Customer表导入，然后执行下列语句UDATE a SET a.cCusBankCode =b.ccusbankcode from Customer a ,821customer b WHERE a.ccuscode=b.ccuscode and (LEN(a.cCusBank) > 0) and a.ccusbankcode is null INSERT INTO CustomerBank (cCusCode, cBank,cbranch,caccountnum,caccountname) SELECT ccuscode, ccusbankcode,ccusbank,ccusaccount,ccusname from customer where ccuscode not in (select ccuscode from customerbank) and len(ccusbankcode)>0 |
| 解决方案： | 由于升级过程中导致CustomerBank表中记录丢失造成，先将821数据库里Customer表导入，然后执行下列语句UDATE a SET a.cCusBankCode =b.ccusbankcode from Customer a ,821customer b WHERE a.ccuscode=b.ccuscode and (LEN(a.cCusBank) > 0) and a.ccusbankcode is null INSERT INTO CustomerBank (cCusCode, cBank,cbranch,caccountnum,caccountname) SELECT ccuscode, ccusbankcode,ccusbank,ccusaccount,ccusname from customer where ccuscode not in (select ccuscode from customerbank) and len(ccusbankcode)>0 |
| 相关补丁： | |
| 版本： | 其他 |
| 模块： | 其他 |
| 产品： | U870 |
| 问题名称： | 821升级到870，基础档案的客户档案里，进入修改任意资料保存后该客户的银行资料就消失不见了 |
| 最后更新： | 2007-06-19 00:00:00 |