上传的图片

  20191251155972.png [ 182.91 KB 1357×619 ] (缩略时请点击查看原图)

 

查询出这个单据总共有多少个过滤条件

SELECT * FROM ICClassProfile WHERE ( FUserID=16405)  AND FTranType =1006004

ftrantype用这个语句查询

SELECT * FROM ICClassType

删除对应的过滤条件

delete ICClassProfile WHERE ( FUserID=16405)  AND FTranType =1006004

工业单据过滤条件

SELECT * FROM ICSchemeProfile WHERE FTranType=2 and FSchemeID=5425
SELECT * FROM ICSchemeProfileEntry WHERE FSchemeID=5425