Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> For only ORACLE Guru

For only ORACLE Guru

From: supporto <supporto_at_tamautomazione.com>
Date: Thu, 04 Jul 2002 10:37:26 GMT
Message-ID: <GzVU8.33475$Jj7.882650@news1.tin.it>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US