Bug in ZeosLib

[BasiL]

ZEOS 6.6.0 & ZEOS 6.6.1
FB 2.0.1.12855
Delphi 7

Error in ZeosLib when using several tables. See to image.

[BasiL]

Programe and database

[BasiL]

But if use CAST in SELECT, then all well.

Code: Select all

select 1, CAST(L.PARAM02 AS CHAR(100))
  from TZAJAV Z
         left join TDOGOVOR D on d.ID=z.IDDogovor
         left join TANKETA_FIZ AF on af.ID=z.IDAnketa
         left join TANKETA AJ on aj.ID=z.IDAnketa,
       TLIZINGODATEL L
 where z.ID  = 1

Sorry for my poor english :-)

[cipto_kh]

Or try like this:

Code: Select all

  select L.PARAM02, 1, L.PARAM02 one
  from TZAJAV Z
         left join TDOGOVOR D on d.ID=z.IDDogovor
         left join TANKETA_FIZ AF on af.ID=z.IDAnketa
         left join TANKETA AJ on aj.ID=z.IDAnketa,
       TLIZINGODATEL L
 where z.ID  = 1

Yes, this is a serious bug. Can you add this bug into http://zeosbugs.firmos.at

thx

[BasiL]

2cipto_kh

SELECT dynamic, so where will be this field is not known.

Yes, this is a serious bug. Can you add this bug into http://zeosbugs.firmos.at

http://zeosbugs.firmos.at/view.php?id=61