Subject Re: [ib-support] Casting integer to integer , was:Expression evaluation
Author Marcin Bury
Helen

> This looks suspect too:
>
> > > , cast(count(R.kod_8) as integer) as ile
>
> I think it it is invalid to try to cast an integer as an integer. Should
be
>
> , count(R.kod_8) as ile

For reporting in this case I use ZReport (for dot matrix printers) with
TIBOQuery, and I encountered problem that IBO returned Int64 value for that
field. Since ZReport has problems with Int64 fields, so I have to explicitly
cast it to standard 32 bit integer.

Marcin