15-01-2021, 12:53 PM
(15-01-2021, 12:06 PM)sysme escribió: 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";
Hi, I have just tried that code & the same thing, once I start the tpv, the file empties as in the screenshotsattached