自定义项被引用后,在前台进行修改和删除时提示数据已被引用。
如何处理?
如何处理?
select * from bd_defquote where fieldname='vuserdef14' for update 查询自定义项引用表(bd_defquote)
select * from bd_defdef for update 查询定义自定义项
select b.vuserdef14, b.* from ic_general_b b where b.vuserdef14 is not null or b.vuserdef14 ='' 查询自定义项14在出库单表体中的引用
update ic_general_b set vuserdef14 =null where vuserdef14 is not null or vuserdef14 ='' 置空出库单表体中vuserdef14字段内容
select * from bd_defdef for update 查询定义自定义项
select b.vuserdef14, b.* from ic_general_b b where b.vuserdef14 is not null or b.vuserdef14 ='' 查询自定义项14在出库单表体中的引用
update ic_general_b set vuserdef14 =null where vuserdef14 is not null or vuserdef14 ='' 置空出库单表体中vuserdef14字段内容
清除缓存。ok。
转载于:https://blog.51cto.com/mjingy/1127842