|
发表于 2023-4-7 13:33:57
|
显示全部楼层
/*单个物料强制开启批次管理*/
select bInvBatch ,* from inventory
where cinvcode = '5080200059'
UPDATE inventory set bInvBatch = 1
where cinvcode = '5080200059'
--------------------------------------------------------------------------------------------------------------------------------
/*多个物料强制开启批次管理*/
select bInvBatch ,* from inventory
where cinvcode in ( '5080200097','5080200098','5080200099','5080200100','5080200101','5080200102')
UPDATE inventory set bInvBatch = 1
where cinvcode in ( '5080200097','5080200098','5080200099','5080200100','5080200101','5080200102')
|
|