思迅软件知识库
| 【问】菜品编码类型变更时提示重复? | ||
| 【适用版本】食通天5 | 【模块】基础资料 | 【点击数】49 |
| 【知识编号】C2012051100030 | ||
| 【问题描述】菜品编码类型变更时提示:资料更新失败！不能在对象’cybr_cp_dish_print’中插入重复键? | ||
use issrestv5
go
delete cybr_cp_dish_print where ch_dishno not in (select ch_dishno from cybr_bt_dish)
use issrestv5
go
delete cybr_cp_dish_print where ch_dishno not in (select ch_dishno from cybr_bt_dish)
