15-01-2021, 12:06 PM
I don't understand why the original script i gave you is not working, test this one (in the file wich Sysme delete the code after restart):
Código:
delete from almacen_complementg;
insert into almacen_complementg (id_centro,id_empresa,id_almacen,id_tipo_comg,id_complementog,cantidad,stock_minimo,complementog,variacion,desc_variacion)
select "01","001","01",id_tipo_comg,id_complementog,0,0,complementog,0,"" from complementog where cafeteria = "S";