用友修改UFSYSTEM最大单据号SQL语句

1、用友修改ufsystem最大单据号sql语句故障1：在保存任何单据时，出现用友单据保存提示违反了primary key约束*不能在对象*中插入重复键。新增单据保存失败的情况时，在sql查询器中，执行以下语句，就能解决。故障2:不能在具有唯一索引aardrecord_pk的对象rdrecord中插入重复键的行。 不能在具有唯一索引aardrecords_pk的对象rdrecords中插入重复键的行。故障3：发货单（销售发票）不能保存，提示操作过程中发生资源共享冲突，可能单据号重复update ua_identity set ifatherid=(select max(dlid)from ufda

2、ta_008_2013.dispatchlist),ichildid=(select max(idlsid)from ufdata_008_2013.dispatchlists) where cacc_id=008 and cvouchtype=dispatch update ufsystem.ua_identity set ifatherid=(select case when max(sbvid) is not null then max(sbvid) else 0 end as id from ufdata_008_2013.salebillvouch),ichildid=(select

3、 case when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.salebillvouchs)where cacc_id=008 and cvouchtype=billvouch goupdate ufsystem.ua_identity set ifatherid=(select case when max(poid) is not null then max(poid) else 0 end as id from ufdata_008_2013.po_pomain),

4、ichildid=(select max(id) as autoid from ufdata_008_2013.po_podetails)where cacc_id=008 and cvouchtype=pomain goupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.justinvouch),ichildid=(select case when max(autoid) is not

5、 null then max(autoid) else 0 end as autoid from ufdata_008_2013.justinvouchs)where cacc_id=008 and cvouchtype=jugoupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.pu_arrivalvouch),ichildid=(select case when max(autoid

6、) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.pu_arrivalvouchs)where cacc_id=008 and cvouchtype=puarrivalgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.pu_appvouch),ichildid=(select case

7、when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.pu_appvouchs)where cacc_id=008 and cvouchtype=puappgoupdate ufsystem.ua_identity set ifatherid=(select case when max(pbvid)is not null then max(pbvid) else 0 end as id from ufdata_008_2013.purbillvouch),ichildid=

8、(select case when max(id) is not null then max(id) else 0 end as autoid from ufdata_008_2013.purbillvouchs)where cacc_id=008 and cvouchtype=purbillgoupdate ufsystem.ua_identity set ifatherid=(select case when max(psvid)is not null then max(psvid) else 0 end as id from ufdata_008_2013.pursettlevouch)

9、,ichildid=(select case when max(id) is not null then max(id) else 0 end as autoid from ufdata_008_2013.pursettlevouchs)where cacc_id=008 and cvouchtype=purstidgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id) is not null then max(id) else 0 end as id from ufdata_008_2013.sa_quoma

10、in),ichildid=(select case when max(autoid) is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.sa_quodetails)where cacc_id=008 and cvouchtype=quomaingoupdate ufsystem.ua_identity set ifatherid=(select case when max(id)is not null then max(id) else 0 end as id from ufdata_008_2013.

11、so_somain),ichildid=(select case when max(isosid) is not null then max(isosid) else 0 end as isosid from ufdata_008_2013.so_sodetails)where cacc_id=008 and cvouchtype=somaingoupdate ufsystem.ua_identity set ifatherid=(select case when max(iid)is not null then max(iid) else 0 end as id from ufdata_00

12、8_2013.ap_closebill),ichildid=(select case when max(id)is not null then max(id) else 0 end as autoid from ufdata_008_2013.ap_closebills)where cacc_id=008 and cvouchtype=skgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id)is not null then max(id) else 0 end as id from ufdata_008_20

13、13.transvouch),ichildid=(select case when max(autoid)is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.transvouchs)where cacc_id=008 and cvouchtype=trgoupdate ufsystem.ua_identity set ifatherid=(select case when max(id)is not null then max(id) else 0 end as id from ufdata_008_2013.expensevouch),ichildid=(select case when max(autoid)is not null then max(autoid) else 0 end as autoid from ufdata_008_2013.expensevouchs)where cacc_id=008 and cvoucht