UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA072.dll' AND 1 > 2) OR ( FileName = 'CA072.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA072.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA072' 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( 'CA072', 6, '6.000.048', '6.0.0.49', 'CA072.dll', '', '544KB', 'Ajuste para nuevo esquema de cancelación SAT.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA069.dll' AND 1 > 2) OR ( FileName = 'CA069.dll' AND Version < '6.0.0.50' ) OR ( FileName = 'CA069.dll' AND Version <> '6.0.0.50' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA069' 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( 'CA069', 6, '6.000.048', '6.0.0.50', 'CA069.dll', '', '236KB', 'Corrección al validar activo fijo con vehículo', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA061.dll' AND 1 > 2) OR ( FileName = 'CA061.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA061.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA061' 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( 'CA061', 6, '6.000.048', '6.0.0.49', 'CA061.dll', '', '652KB', 'Cambios menores de interacción', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA057.dll' AND 1 > 2) OR ( FileName = 'CA057.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA057.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA057' 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( 'CA057', 6, '6.000.048', '6.0.0.49', 'CA057.dll', '', '376 KB', 'Nuevo campo para configurar plantilla de email de cancelación.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA056.dll' AND 1 > 2) OR ( FileName = 'CA056.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA056.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA056' 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( 'CA056', 6, '6.000.048', '6.0.0.49', 'CA056.dll', '', '120 KB', 'Cambios menores en la pantalla (Mapas)', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA042.dll' AND 1 > 2) OR ( FileName = 'CA042.dll' AND Version < '6.0.0.50' ) OR ( FileName = 'CA042.dll' AND Version <> '6.0.0.50' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA042' 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( 'CA042', 6, '6.000.048', '6.0.0.50', 'CA042.dll', '', '168KB', 'Mejora para busqueda avanzada en pantalla', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA041.dll' AND 1 > 2) OR ( FileName = 'CA041.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA041.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA041' 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( 'CA041', 6, '6.000.048', '6.0.0.49', 'CA041.dll', '', '144KB', 'Mejora para busqueda avanzada de datos en pantalla', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA040.dll' AND 1 > 2) OR ( FileName = 'CA040.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA040.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA040' 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( 'CA040', 6, '6.000.048', '6.0.0.49', 'CA040.dll', '', '80KB', 'Mostrar correctamente cuantos productos estan asignados los proveedores y compradores.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA037.dll' AND 1 > 2) OR ( FileName = 'CA037.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA037.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA037' 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( 'CA037', 6, '6.000.048', '6.0.0.49', 'CA037.dll', '', '148 KB', 'Cambios menores de interfaz', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA035.dll' AND 1 > 2) OR ( FileName = 'CA035.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA035.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA035' 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( 'CA035', 6, '6.000.048', '6.0.0.49', 'CA035.dll', '', '112KB', 'Fix: Guardar campos adicionales.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT ***