For the first time, i try to use common table expression(CTE) (with clause in SQL-select) under TD 5.2. Database is SQL-server 2008 R2. The select runs fine under SQL Server management studio and runs fine from excel by ODBC-connection.
From within TD i always receive error 113 on executing the SqlPrepareAndExecute command.
The Sql-command looks like:
Code: Select all
Set strSql = '
with inci as
(select qseko.ENDPRODUKTID, qseko.ROHPRODUKTID, qsrin.HWI_NUMMER, SUM(qseko.menge_in_g) as Prozent
from QSEKO, QSRIN
where qsrin.ROHPRODUKTID = qseko.ROHPRODUKTID
group by qseko.endproduktid, qseko.ROHPRODUKTID, qsrin.HWI_NUMMER)
select inci.rohproduktid, inci.hwi_nummer, QSROH.BEZEICHNUNG,
inci.prozent
into :udvListe[i].nrRohproduktId, :udvListe[i].nrHwinummer, :udvListe[i].strHandelsname,
:udvListe[i].nrProzent
from inci, qsroh
where inci.endproduktid = :nrRezepturId
and qsroh.ROHPRODUKTID = inci.ROHPRODUKTID
'