Situação/Requisito: | Ao executar o cálculo do dissídio com banco de dados postgres, ocorre error.log: - THREAD ERROR ([13784], graziela.affonso, SPOD2720) 19/10/2018 09:39:55
: Error : 1 (42P10) (RC=-1) - ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list; Error while executing the query ( From tPostgresConnection::GetQueryFile ) Thread ID [4788] User [Administrador] IO [3068] Tables [29] MaxTables [29] Comment [GPEM690 - TCPIP - ThreadID(13784)] SP [] Traced [No] SQLReplay [No] InTran [No]DBEnv [POSTGRES/IPRH112] DBThread [(ID 5108)] Started [19/10/2018 09:38:06] IP [10.172.22.187:2348] IDLE [] InTransact [] Memory [628689] Running [ROP_QUERY]RCV [328163] SND [1106772] TCBuild [20171117-20180424] SELECT DISTINCT RCH_FILIAL,RCH_PER,RA_PROCES,RCH_DTFECH,RA_FILIAL FROM RCH010 RCH INNER JOIN SRA010 SRA ON RCH_PROCES = RA_PROCES AND ' ' = ' ' WHERE RCH_PROCES = '00006' AND RCH_PER = ' ' AND RCH_NUMPAG = ' ' AND RCH_ROTEIR = ' ' AND RCH.D_E_L_E_T_= ' ' AND SRA.D_E_L_E_T_= ' ' ORDER BY RCH.RCH_FILIAL, RCH.RCH_PER, SRA.RA_PROCES on __EXECSQL(APLIB300.PRW) 17/10/2018 16:46:22 line : 134
|