Error extraño en C++
Publicado por victor (1 intervención) el 06/09/2016 19:33:14
hola a todos.
tengo un problema en una compilacion de un SQL en C++
Tengo este Select que ejecuta sin problemas en la BDD.
SELECT A.NUM_ABONADO,
(SELECT concb.COD_CONCCOBR from FA_FACTCOBR concb where concb.COD_CONCFACT = a.COD_CONCEREL ) COD_CONCCOBR,
(SELECT concb2.COD_CONCCOBR from FA_FACTCOBR concb2 where concb2.COD_CONCFACT = a.COD_CONCEREL ) COD_CONCCOBR_1,
IMP_FACTURABLE,
1 as SEQ_CUOTAS,
1 as ORD_CUOTA ,
A.COD_PRODUCTO
FROM FA_FACTCONC_220516 A, FA_FACTCOBR B
WHERE A.IND_ORDENTOTAL = 40330851
AND A.COLUMNA > 0
AND A.COD_CONCEPTO = B.COD_CONCFACT
AND B.COD_CONCCOBR <> 33
AND A.COD_TIPCONCE =2
pero al compilar en C++, me entrega este error.
PCC-I-02106, Userid only used when SQLCHECK = FULL, userid ignored.
Syntax error at line 700, column 20, file ./pc/ClassDbProc.pc:
Error at line 700, column 20 in file ./pc/ClassDbProc.pc
(SELECT concb.COD_CONCCOBR
...................1
PCC-S-02201, Encountered the symbol "concb" when expecting one of the following:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
alguna idea.... del problema....
tengo un problema en una compilacion de un SQL en C++
Tengo este Select que ejecuta sin problemas en la BDD.
SELECT A.NUM_ABONADO,
(SELECT concb.COD_CONCCOBR from FA_FACTCOBR concb where concb.COD_CONCFACT = a.COD_CONCEREL ) COD_CONCCOBR,
(SELECT concb2.COD_CONCCOBR from FA_FACTCOBR concb2 where concb2.COD_CONCFACT = a.COD_CONCEREL ) COD_CONCCOBR_1,
IMP_FACTURABLE,
1 as SEQ_CUOTAS,
1 as ORD_CUOTA ,
A.COD_PRODUCTO
FROM FA_FACTCONC_220516 A, FA_FACTCOBR B
WHERE A.IND_ORDENTOTAL = 40330851
AND A.COLUMNA > 0
AND A.COD_CONCEPTO = B.COD_CONCFACT
AND B.COD_CONCCOBR <> 33
AND A.COD_TIPCONCE =2
pero al compilar en C++, me entrega este error.
PCC-I-02106, Userid only used when SQLCHECK = FULL, userid ignored.
Syntax error at line 700, column 20, file ./pc/ClassDbProc.pc:
Error at line 700, column 20 in file ./pc/ClassDbProc.pc
(SELECT concb.COD_CONCCOBR
...................1
PCC-S-02201, Encountered the symbol "concb" when expecting one of the following:
( ) * + - / . @ | at, day, hour, minute, month, second, year,
alguna idea.... del problema....
Valora esta pregunta


0