UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'MV016.dll' AND 1 > 2) OR ( FileName = 'MV016.dll' AND Version < '6.0.0.50' ) OR ( FileName = 'MV016.dll' AND Version <> '6.0.0.50' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'MV016' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'MV016', 6, '6.000.048', '6.0.0.50', 'MV016.dll', '', '148 KB', 'Cambios menores en la transacción', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'MV008.dll' AND 1 > 2) OR ( FileName = 'MV008.dll' AND Version < '6.0.0.52' ) OR ( FileName = 'MV008.dll' AND Version <> '6.0.0.52' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'MV008' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'MV008', 6, '6.000.048', '6.0.0.52', 'MV008.dll', '', '560 KB', 'Corrección al obtener costos de productos con tipo de costeo PEPS o UEPS.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'MV002.dll' AND 1 > 2) OR ( FileName = 'MV002.dll' AND Version < '6.0.0.50' ) OR ( FileName = 'MV002.dll' AND Version <> '6.0.0.50' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'MV002' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'MV002', 6, '6.000.048', '6.0.0.50', 'MV002.dll', '', '488 KB', 'Validar que las cantidades, y costos sean numéricos al importar con F9.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'MV001.dll' AND 1 > 2) OR ( FileName = 'MV001.dll' AND Version < '6.0.0.51' ) OR ( FileName = 'MV001.dll' AND Version <> '6.0.0.51' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'MV001' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'MV001', 6, '6.000.048', '6.0.0.51', 'MV001.dll', '', '408 KB', 'Corección al importar datos desde un plantilla que contiene productos loteados.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'msxml4r.dll' AND 13 > 2) OR ( FileName = 'msxml4r.dll' AND Version < '4.10.9404.0' ) OR ( FileName = 'msxml4r.dll' AND Version <> '4.10.9404.0' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'msxml4r' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'msxml4r', 6, '6.000.048', '4.10.9404.0', 'msxml4r.dll', '', '80 KB', 'Compatibilidad para el webPro.dll', 13, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'msxml4.dll' AND 13 > 2) OR ( FileName = 'msxml4.dll' AND Version < '4.20.9818.0' ) OR ( FileName = 'msxml4.dll' AND Version <> '4.20.9818.0' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'msxml4' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'msxml4', 6, '6.000.048', '4.20.9818.0', 'msxml4.dll', '', '1.2 MB', 'Compatibilidad para el webPro.dll', 13, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'msgBoxPro.dll' AND 0 > 2) OR ( FileName = 'msgBoxPro.dll' AND Version < '6.0.0.52' ) OR ( FileName = 'msgBoxPro.dll' AND Version <> '6.0.0.52' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'msgBoxPro' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'msgBoxPro', 6, '6.000.048', '6.0.0.52', 'msgBoxPro.dll', '', '312 KB', 'Mejoras de interación', 0, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'mprows_gral.zip' AND 6 > 2) OR ( FileName = 'mprows_gral.zip' AND Version < '6.000.048' ) OR ( FileName = 'mprows_gral.zip' AND Version <> '6.000.048' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'mprows_gral' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'mprows_gral', 6, '6.000.048', '6.000.048', 'mprows_gral.zip', '%ASP.PATH%\mprows\', '1 KB', 'Mejoras de conexión.', 6, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'mprows.dll' AND 0 > 2) OR ( FileName = 'mprows.dll' AND Version < '6.0.0.50' ) OR ( FileName = 'mprows.dll' AND Version <> '6.0.0.50' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'mprows' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'mprows', 6, '6.000.048', '6.0.0.50', 'mprows.dll', '', '788 KB', 'Mejoras para Servicios en WS', 0, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'MproSys.exe' AND 2 > 2) OR ( FileName = 'MproSys.exe' AND Version < '6.0.0.65' ) OR ( FileName = 'MproSys.exe' AND Version <> '6.0.0.65' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'MproSys' AND Major = 6 AND Version_Instalador = '6.000.048' INSERT INTO EMPRESAS..Update_Bin ( Transaccion, Major, Version_Instalador, Version, FileName, FilePath, FileSize, Memo, Tipo, Opcional, Ejecutar, Sobreescribir, Fecha_Ult_Modif, Up_Binary ) VALUES ( 'MproSys', 6, '6.000.048', '6.0.0.65', 'MproSys.exe', '', '984 KB', 'Mejoras al actualizar servidores de timbrado', 2, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT ***