回答： 此问题一般是颜色已经被单据占用，所以不允许删除。需要找到单子 ，把单子里面的这个款色删除，就可以改了。

如果是IT可以看下面**************

---款式资料是否使用（把款号替换成需要查询的款号，色号替换为颜色编号,尺码更改）
IF EXISTS (SELECT distinct 1 FROM dat_cgd_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 采购单
IF EXISTS (SELECT distinct 1 FROM dat_ccd_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 裁床单
IF EXISTS (SELECT distinct 1 FROM dat_ckrk_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 采购入库单
IF EXISTS (SELECT distinct 1 FROM dat_ckth_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 采购退货单
IF EXISTS (SELECT distinct 1 FROM dat_dhd_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 订货单
IF EXISTS (SELECT distinct 1 FROM dat_gtss_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 店铺销售单
IF EXISTS (SELECT distinct 1 FROM dat_ckpf_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1  批发出货单
IF EXISTS (SELECT distinct 1 FROM dat_ckpt_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 批退入库单
IF EXISTS (SELECT distinct 1 FROM dat_bhd_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 补货单
IF EXISTS (SELECT distinct 1 FROM dat_phd_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1  配货单
IF EXISTS (SELECT distinct 1 FROM dat_ckfc_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 调拨发货单
IF EXISTS (SELECT distinct 1 FROM dat_cksh_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 调拨收货单
IF EXISTS (SELECT distinct 1 FROM dat_zxd_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 装箱单
IF EXISTS (SELECT distinct 1 FROM dat_ckds_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 货品调整单
IF EXISTS (SELECT distinct 1 FROM dat_ckpd_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 货品盘点
IF EXISTS (SELECT distinct 1 FROM dat_ckcy_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 盘点差异单
IF EXISTS (SELECT distinct 1 FROM esm_dat_cgjh_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1  生产计划单
IF EXISTS (SELECT distinct 1 FROM esm_dat_sctz_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1 生产通知采购单
IF EXISTS (SELECT distinct 1 FROM esm_dat_ckpt_pass_dtl WHERE Fas_id='款号' and col_id='色号' and siz_id='M')
SELECT 1  退货申请单
    SELECT 0