查询未审核单据
SELECT * FROM wf_Flow_inst WHERE bil_id = 'QC' AND sh_state <> 4;
把未审核单据插入到临时表中
SELECT * into A00002 FROM wf_Flow_inst WHERE bil_id = 'QC' AND sh_state <> 4;
删除未审单据:
delete FROM wf_Flow_inst WHERE bil_id = 'QC' AND sh_state <> 4;
修改完成后再插入回来:
INSERT INTO wf_Flow_inst select * FROM A00002
注意 QC是单据识别码
最后修改:2023 年 06 月 02 日
© 允许规范转载