Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> For only ORACLE Guru
Dear friends, from my client with ADO + oracle driver ODBC 8i (v.8.1.77)
when I try to execute a SQL Statement I alway receive the message
-2147217900 [Oracle][ODBC]Syntax error or access violation.
When I Delete from query table CentriCo (is better if you see the image in attach) I didn't error
Can anyone help me?
select count(*) from {oj Contatori RIGHT JOIN (Ubicazio RIGHT JOIN (TipStrut RIGHT JOIN (TemplPre RIGHT JOIN ((CentriCo RIGHT JOIN Struttur ON CentriCo.Id = Struttur.IdCentriCo) INNER JOIN (Richiede RIGHT JOIN (Priorita RIGHT JOIN (Commesse RIGHT JOIN (CodGuast RIGHT JOIN (Storico INNER JOIN Attivita ON Storico.Id = Attivita.IdStorico) ON CodGuast.Id = Storico.IdGuasto) ON Commesse.Id = Storico.IdCommessa) ON Priorita.Id = Storico.IdPriorita) ON Richiede.Id = Storico.IdRichied) ON Struttur.Id =
Attivita.IdStruttur) ON TemplPre.Id = Attivita.IdTemplPre) ON TipStrut.Id = Struttur.IdTipStrut) ON Ubicazio.Id = Struttur.IdUbicazio) ON Contatori.Id = TemplPre.IdContatori } WHERE Storico.F_Stato IN ( 1,2) AND((Attivita.NProgr = 0)) AND ((Storico.F_TipMan = 0 And Storico.F_TipPreve IN (0,3,1,2,5)) OR (Storico.F_TipMan IN (1,2))) Received on Thu Jul 04 2002 - 05:37:26 CDT