09-02-2022, 11:05 AM
Ok, haz una copia de seguridad (importante) en SISTEMA->COPIAS DE SEGUIRIDAD, luego accede a SISTEMA->MANTENIMIENTO->Pestaña CONSOLA DB y ejecuta estos scripts (uno a uno):
delete from ventadir_comg2 where (id_venta,id_linea) in (select id_venta,id_linea from ventadir_comg);
delete from ventadirecta2 where id_venta in (select id_venta from ventadirecta);
delete from factura2 where (id_factura,serie) in (select id_factura,serie from factura);
delete from tiquet2 where (id_tiquet,serie) in (select id_tiquet,serie from tiquet);
delete from pagoscobros2 where id_pagoscobros in (select id_pagoscobros from pagoscobros);
delete from apcajas2 where id_apcajas in (select id_apcajas from apcajas);
Tras esto deberías poder recuperar los datos.
Ya me dices.
delete from ventadir_comg2 where (id_venta,id_linea) in (select id_venta,id_linea from ventadir_comg);
delete from ventadirecta2 where id_venta in (select id_venta from ventadirecta);
delete from factura2 where (id_factura,serie) in (select id_factura,serie from factura);
delete from tiquet2 where (id_tiquet,serie) in (select id_tiquet,serie from tiquet);
delete from pagoscobros2 where id_pagoscobros in (select id_pagoscobros from pagoscobros);
delete from apcajas2 where id_apcajas in (select id_apcajas from apcajas);
Tras esto deberías poder recuperar los datos.
Ya me dices.