ADO(X) problem sa dodavanjem query-ja
Kada programski kroz DAO dodajem query i kada u Access-u paste-ujem
tekst istog query-ja sve je OK tj. query je dodat kroz DAO, a u Access-u
se izvrsi bez greske. Medjutim kada pokusam da dodam isti query programski
kroz ADOX:
sSQL="Parameters ..."
DBCMD.CommandText = sSQL
DBADOX.Procedures.Append "MyQuery", DBCMD
JET mi prijavi gresku:
"The SELECT statement includes a reserved word or an argument name is mispelled
or missing, or the punctuation is incorrect".
Ima li neko ideju zasto ? ADOX bug, podesavanje JETa ili nesto trece ?
Tekst query-ja je:
"PARAMETERS InDocID Long;
SELECT RT.TipPor, V.ValSimbol, SK.Naziv AS SKLNAZIV, K.Naziv AS Kupnaziv, K.Lice, K.TipKup, K.Tel, K.Fax, K.Adr, K.BankRek, SR.Pozicija, SR.Kol, SR.Cena, E.Artikal, E.Tip, E.Boja, E.Naziv, E.Jed, SR.PPromet AS PP, SR.Popust AS SASPOP, SR.SCena, (SELECT SUM(Procenat) FROM (RacTip INNER JOIN SasRacTip ON RacTip.RacTip=SasRacTip.RacTip) INNER JOIN Porezi ON SasRacTip.Grupa=Porezi.Grupa WHERE RacTip.RacTip=R.RacTip AND SasRacTip.TipPor=0 AND SasRacTip.DatOd<=R.DatDoc AND (ISNULL(SasRacTip.DatDo) OR SasRacTip.DatDo > R.DatDoc) AND Porezi.KontoArtikla=E.TarBr) AS PROC, SR.SklID AS SSklID, SR.OCena, XO.XOpis, SR.IDXOpis, RT.PorUCeni, SR.TotTaksa, SR.Porez AS RUC, OTP.DatOtp, OTP.BrOtp, OTP.OtpID, SR.CenaV, R.RacLink, R.RacBr, R.DatIsp, R.DatDoc, R.DatRok, R.DocTip, R.RacTip, R.SklID, R.Total, R.Popust, R.Porez, R.NabVred, R.FAnul, R.FPokazuj, R.DopPod, R.KupID, R.ImeKup, R.ValID, R.Kurs, R.TotalNDS, R.NotID, R.KorID, R.DocBr, R.RedBrZirRac, R.TotRabat, R.TotPU, R.PrikazPP, R.FKomp, R.DopHID, R.DopLID, R.DocStatus, R.fAltJed1, R.fAltJed2, R.DocRefID, R.SekRefID, (SELECT LDesc FROM LongDesc WHERE LdsID=R.DopHID) AS DopKupPod, K.ZIP, K.NazivMesta, K.NazivDrzave, (SELECT SUM(Suma) FROM Uplate WHERE Link=InDocID) AS Uplaceno, K.RegBr, (SELECT SUM(Iznos) FROM RacuniRokUpl WHERE RacLink=InDocID) AS SumOdlozeno, L.LicID, L.Ime, L.Prezime, L.IDTitula, L.LicTel, L.LicMob, L.LicEma, L.LicSifra, L.LicOpisRad, L.LicIDNapom, L.LicFax, (SELECT Konto FROM KontneGrupeSas WHERE KGrID=1130 AND Pozicija=L.IDTitula) AS Titula, K.Email, K.Komentar, KOR.Ime AS KorNaz,SR.SumNDS AS PDV
FROM (((((((((Racuni AS R INNER JOIN ViewNazivEx AS K ON R.KupID = K.KupID) INNER JOIN RacTip AS RT ON R.RacTip = RT.RacTip) INNER JOIN Valuta AS V ON R.ValID = V.ValID) INNER JOIN SasRac AS SR ON R.RacLink=SR.RacLink) INNER JOIN Elementi AS E ON SR.ElID=E.ElID) INNER JOIN Skladista AS SK ON SR.SklID=SK.SklID) LEFT JOIN (SELECT TOP 1 O.DatOtp,O.BrOtp, O.OtpID, DL.DocID, DL.Link FROM Otpremnice AS O INNER JOIN DocLink AS DL ON O.OtpID=DL.Link OR O.OtpID=DL.DocID WHERE DL.DocID=InDocID OR DL.Link=InDocID) AS OTP ON R.RacLink = OTP.DocID OR R.RacLink=OTP.Link) LEFT JOIN DopOpis AS XO ON SR.IDXOpis = XO.IDXOpis) LEFT JOIN Lica AS L ON R.DopHID=L.LicID) LEFT JOIN Korisnici AS KOR ON R.KorID=KOR.KorID
WHERE R.RacLink=InDocID
ORDER BY SR.Pozicija,SR.SasRacID;"
 |  |
 |
Re: ADO(X) problem sa dodavanjem query-ja - resenje