[firebase-br] isql x Ibexpert

[Daniel Reis]

Bom dia,


Existe alguma diferença entre os comandos executados pelo Ibexpert e o Isql?

Alguns scripts que executo no IBexpert são executados normalmente sem erros e no Isql apresentam erros. Segue um exemplo.


-Ibexpert

UPDATE TB_CPJ SET SCL_CDOBSI003 = 3 WHERE CPJ_CDCLII006 IN (SELECT CPJ_CDCLII006
 FROM TB_CPJ CPJ INNER JOIN TB_CRE CRE ON (CPJ.CPJ_CDCLII006 = CRE.CPJ_CDCLII006)
                 INNER JOIN TB_CPF CPF ON (CPJ.CPJ_CDCLII006 = CPF.CPJ_CDCLII006)
WHERE CRE.CRE_SERIEA003 = 'UNI'
AND CRE.CRE_SITUAA001    <> 6
AND CRE.EMP_CDEMPA003  = '001'        
AND CRE.CRE_DTVEND000   < (SELECT cast ('now' as timestamp) - 15 from rdb$database) 
AND CRE.CRE_VLPAGN017   < CRE.CRE_VALORN017
AND CRE.CRE_EMFATA003   <> '1'
AND CPJ.CPJ_CCOEMA001   = 'S'
AND CRE.CRE_VALORN017   > 5
AND CRE.CPJ_CDCLII006    <>  85 
AND CPJ.SCL_CDOBSI003 NOT IN (3,6)
);

-Isql
UPDATE TB_CPJ SET SCL_CDOBSI003 = 3 WHERE CPJ_CDCLII006 IN (SELECT CPJ_CDCLII006
 FROM TB_CPJ CPJ INNER JOIN TB_CRE CRE ON (CPJ.CPJ_CDCLII006 = CRE.CPJ_CDCLII006)
                 INNER JOIN TB_CPF CPF ON (CPJ.CPJ_CDCLII006 = CPF.CPJ_CDCLII006)
WHERE CRE.CRE_SERIEA003 = 'UNI'
AND CRE.CRE_SITUAA001 <> 6
AND CRE.EMP_CDEMPA003 = '001'     
AND CRE.CRE_DTVEND000 < (SELECT cast ('now' as timestamp) - 15 from rdb$database) 
AND CRE.CRE_VLPAGN017 < CRE.CRE_VALORN017
AND CRE.CRE_EMFATA003 <> '1'
AND CPJ.CPJ_CCOEMA001 = 'S'
AND CRE.CRE_VALORN017 > 5
AND CRE.CPJ_CDCLII006 <>  85  
AND CPJ.SCL_CDOBSI003 NOT IN (3,6) 
);
-Ambiguous field name between table TB_CPJ and table TB_CRE and table TB_CPF
-CPJ_CDCLII006


Daniel Reis