UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA155.dll' AND 1 > 2) OR ( FileName = 'CA155.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA155.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA155' 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( 'CA155', 6, '6.000.048', '6.0.0.49', 'CA155.dll', '', '148KB', 'Corrección al guardar la tabla de vacaciones', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA154.dll' AND 1 > 2) OR ( FileName = 'CA154.dll' AND Version < '6.0.0.50' ) OR ( FileName = 'CA154.dll' AND Version <> '6.0.0.50' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA154' 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( 'CA154', 6, '6.000.048', '6.0.0.50', 'CA154.dll', '', '284 KB', 'Ajustes a la longitud de los textos de la fórmulas y funcionalidad de los botenes de las pestañas de configuración.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA146.dll' AND 1 > 2) OR ( FileName = 'CA146.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA146.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA146' 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( 'CA146', 6, '6.000.048', '6.0.0.49', 'CA146.dll', '', '84 KB', 'Corrección a campos adicionales.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA143.dll' AND 1 > 2) OR ( FileName = 'CA143.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA143.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA143' 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( 'CA143', 6, '6.000.048', '6.0.0.49', 'CA143.dll', '', '176 KB', 'Correcciones al consultar almacen por F2', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA128.dll' AND 1 > 2) OR ( FileName = 'CA128.dll' AND Version < '6.0.0.54' ) OR ( FileName = 'CA128.dll' AND Version <> '6.0.0.54' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA128' 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( 'CA128', 6, '6.000.048', '6.0.0.54', 'CA128.dll', '', '220KB', 'Ajustes para parcialidades, uso de cfdi, leyenda fiscal.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA100.dll' AND 1 > 2) OR ( FileName = 'CA100.dll' AND Version < '6.0.0.50' ) OR ( FileName = 'CA100.dll' AND Version <> '6.0.0.50' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA100' 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( 'CA100', 6, '6.000.048', '6.0.0.50', 'CA100.dll', '', '164KB', '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 = 'CA098.dll' AND 1 > 2) OR ( FileName = 'CA098.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA098.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA098' 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( 'CA098', 6, '6.000.048', '6.0.0.49', 'CA098.dll', '', '80 KB', 'Cambios menores de interfaz', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA096.dll' AND 1 > 2) OR ( FileName = 'CA096.dll' AND Version < '6.0.0.49' ) OR ( FileName = 'CA096.dll' AND Version <> '6.0.0.49' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA096' 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( 'CA096', 6, '6.000.048', '6.0.0.49', 'CA096.dll', '', '164 KB', 'Corrección al capturar almacén por F2', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA092.dll' AND 1 > 2) OR ( FileName = 'CA092.dll' AND Version < '6.0.0.51' ) OR ( FileName = 'CA092.dll' AND Version <> '6.0.0.51' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA092' 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( 'CA092', 6, '6.000.048', '6.0.0.51', 'CA092.dll', '', '120KB', 'Mejora para mostrar código de barras.', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT *** UPDATE EMPRESAS..Ws_Bin SET Actualizado = 'NO' WHERE (FileName = 'CA089.dll' AND 1 > 2) OR ( FileName = 'CA089.dll' AND Version < '6.0.0.51' ) OR ( FileName = 'CA089.dll' AND Version <> '6.0.0.51' AND 'NO' = 'SI') SELECT Up_Binary FROM EMPRESAS..Update_Bin WHERE Transaccion = 'CA089' 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( 'CA089', 6, '6.000.048', '6.0.0.51', 'CA089.dll', '', '196KB', 'Corrección al buscar Materia Prima por F2', 1, 'NO', 'SI', 'NO', GETDATE(), null ) *** BEGIN TRANSACION *** *** COMMIT ***