Ocorrência: | Error : 904 - ORA-00904: "SUBSTRING": invalid identifier
( From tOracleConnection::GetQueryFile )
Thread ID [3336] User [Administrador] IO [149868] Tables [6] MaxTables [33] Comment [] Status [] SP [ ] Traced [No] SQLReplay [No] InTran [No] DBEnv [ORACLE/Homologa] DBThread [(SID 82,24187,1)] Started [05/12/2017 13:01:26] LastIO [05/12/2017 14:43:49] IP [172.16.10.50:5199] RCV [9025376] SND [6829595] TCBuild [20170202-20171004]
SELECT TEW.R_E_C_N_O_ TEWRECNO , AA3.R_E_C_N_O_ AA3RECNO , TEW_FILIAL , TEW_CODMV , AA3_NUMSER FROM TEW060 TEW INNER JOIN AA3060 AA3 ON AA3.D_E_L_E_T_=' ' AND AA3.AA3_NUMSER = TEW.TEW_BAATD AND AA3.AA3_EQALOC = '1' AND SUBSTRING( AA3.AA3_FILIAL, 1, 0 ) = SUBSTRING( TEW.TEW_FILIAL, 1, 0 ) WHERE TEW.D_E_L_E_T_=' ' AND TEW.TEW_FILBAT = ' ' AND TEW.TEW_BAATD <> ' ' on __EXECSQL(APLIB300.PRW) 05/10/2017 18:39:40 line : 126 |