on 05-05-2011 8:09 PM
Hola a todos, encontre un query en un foro pasado y lo edite con el fin de poder lograr que se pueda grabar una asiento que no tenga definido un centro de beneficio de un rango de cuentas en particular, el query corre correctamente y hace lo que deseo, sin embargo ahora al momento de bloquear o desbloquear ya sean cuentas, socios, o articulos el sistema me lanza el siguiente error :
[Micrisoft][SQL Native Client][Sql Server] The conversion of the nvachar value '1010131005000001' overflowed and int column. Maximun integer value exceeded. (CINF)
les paso mi query tambien
DECLARE @CUENTA as NVarchar(15)
SELECT @CUENTA = COUNT(T1.Account)
FROM OJDT T0
INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId
WHERE T0.Number = @list_of_cols_val_tab_del AND T1.Account IN ('401100100100001','401100100200001')
-- CENTRO DE BENEFICIO
DECLARE @CB as NVarchar(15)
SELECT @CB = COUNT(T1.ProfitCode)
FROM OJDT T0
INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId
WHERE T0.Number = @list_of_cols_val_tab_del AND T1.ProfitCode Like '%[(3RIOS)(TINTORER)]%'
IF (@CUENTA != @CB)
BEGIN
SET @error = 102
SET @error_message = 'MS-102 Revisar centros de Beneficio'
END
alguien ha tenido este mismo error ??
saludos
Yessica, pruebalo de esta forma
DECLARE @CUENTA as NVarchar(15)
SELECT @CUENTA = COUNT(T1.Line_ID)
FROM OJDT T0
INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId
WHERE T0.Number = @list_of_cols_val_tab_del AND T1.Account IN ('401100100100001','401100100200001')
DECLARE @CB as NVarchar(15)
SELECT @CB = COUNT(T1.ProfitCode)
FROM OJDT T0
INNER JOIN JDT1 T1 ON T0.TransId = T1.TransId
WHERE T0.Number = @list_of_cols_val_tab_del AND T1.Account IN ('401100100100001','401100100200001')
IF (@CUENTA != @CB)
BEGIN
SET @error = 102
SET @error_message = 'MS-102 Revisar centros de Beneficio'
END
Me cuentas
Slds
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.