> -----Original Message-----
> From: Jörg Schiemann [mailto:schimmi@...]
> Sent: Jueves 4 de Enero de 2001 6:46
>
> For some reason IB6 insists to add '.0000000000' to all calculations of
> barcode when using
>
> ( :P_BAR_PREFIX || ( :P_CATEGORY_ID * ( 100000 + :i ) + :i * 10000 + :i *
> 10 + :P_CATEGORY_ID ) ),
>
> in the SP_GEN_DUMMY_ITEM procedure. I haven't got a clue why why it
> transforms integers this way, but Jason or Helen might know.

I never have seen SP_GEN_DUMMY_ITEM but if some of the values causes the
resul to be a numeric with some scale, there's a chance IB will add zeroes
when converting to string, so maybe a cast to numeric with scale 0 could
help. Also, I don't know if we are talking about dialect 1 or 3, so I can't
say more.

C.