Unable to save source after manually edit query

rbuser

After changing the SQL of a dade query manually i'm unable to svae to
source, always getting a error in the rtl60.bpl.
A preview of the query works fine.

This is the query i'm trying to implement

SELECT TS_CompFeat.Comp_Id,
TS_CompFeat.CompF_Id,
TS_CompFeat.CompF_Name,
TS_CompFeat.CompF_Ext,
TS_DaySalHead.Dsh_Perf,
(SELECT SUM(TS_DaySalTrans2.Cpr_Value*TS_DaySalTrans2.Dst_Tickets)
GBO2
FROM TS_DaySalHead TS_DaySalHead2
INNER JOIN TS_DaySalTrans TS_DaySalTrans2 ON
(TS_DaySalTrans2.Dsh_Id = TS_DaySalHead2.Dsh_Id)
INNER JOIN TS_TickFeat TS_TickFeat2 ON
(TS_TickFeat2.Comp_Id = TS_DaySalHead2.Comp_Id)
AND (TS_TickFeat2.TickF_Id = TS_DaySalHead2.TickF_Id)
INNER JOIN TS_CompFeat TS_CompFeat2 ON
(TS_CompFeat2.Comp_Id = TS_TickFeat2.Comp_Id)
AND (TS_CompFeat2.CompF_Id = TS_TickFeat2.CompF_Id)
WHERE (TS_CompFeat2.Comp_Id = TS_CompFeat.Comp_Id)
AND (TS_CompFeat2.CompF_Id = TS_CompFeat.CompF_Id)
GROUP BY TS_CompFeat2.CompF_Name, TS_CompFeat2.CompF_Ext) AS Snok,
SUM(TS_DaySalTrans.Dst_Tickets) Tickets,
SUM(TS_DaySalTrans.Cpr_Value*TS_DaySalTrans.Dst_Tickets) GBO
FROM TS_DaySalHead TS_DaySalHead
INNER JOIN TS_DaySalTrans TS_DaySalTrans ON
(TS_DaySalTrans.Dsh_Id = TS_DaySalHead.Dsh_Id)
INNER JOIN TS_TickFeat TS_TickFeat ON
(TS_TickFeat.Comp_Id = TS_DaySalHead.Comp_Id)
AND (TS_TickFeat.TickF_Id = TS_DaySalHead.TickF_Id)
INNER JOIN TS_CompFeat TS_CompFeat ON
(TS_CompFeat.Comp_Id = TS_TickFeat.Comp_Id)
AND (TS_CompFeat.CompF_Id = TS_TickFeat.CompF_Id)
WHERE ( TS_DaySalHead.Comp_Id = 'KBRU' )
GROUP BY TS_CompFeat.Comp_Id,
TS_CompFeat.CompF_Id,
TS_CompFeat.CompF_Name,
TS_CompFeat.CompF_Ext,
TS_DaySalHead.Dsh_Perf
ORDER BY Snok DESC


Any suggestions ????

--
Harry Leboeuf
Email Inversed moc.silopenik@fueobelh (For Spam-Reason)
Visit us at http://www.kinepolis.com

digitalmetaphors

This is a known issue and the workaround is to design the report at runtime
if you want to edit the SQL and be able to save the report template. We
don't have a patch for this yet, it only happens at Delphi design time.


Cheers,

Jim Bennett
Digital Metaphors