On Dataset.Open raised "Token unknown" error
Original Reporter info from Mantis: dan
-
Reporter name: Daniel
Original Reporter info from Mantis: dan
- Reporter name: Daniel
Description:
Raised Error:
IBConnection1 : PrepareStatement:
-Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 213
-group
Steps to reproduce:
Set following SQL query to dataset and open it:
select
u.SYNTETICKE,
0 as ANALYTICKE,
u.SYNTETICKE as CISLO,
sum(u.CASTKA) as CASTKA
from
UCTY u
left join STREDISKA s on (u.STREDISKO= s.ID)
where
u.STREDISKO = 300310
group by
u.SYNTETICKE,
u.STREDISKO,
s.NAZEV,
s.ID
order by
u.STREDISKO,
u.SYNTETICKE
Additional information:
This query running without any problem at Lazarus 0.9.8 version.
Mantis conversion info:
- Mantis ID: 1254
- OS: Windows XP SP1
- OS Build: 2600
- Build: 29.09.2005
- Platform: win32
- Version: 0.9.9 (SVN)
- Monitored by: » dan (Daniel)
- Target version: 1.0.0
- LazTarget: 1.0