Subject AW: AW: [firebird-support] Converting with parameters stored in variables?
Author Check_Mail

Hallo Karol,

 

we have a rfc interface with a high bay storage an the telegram defines the different datatypes. If I would create a new material, I must set different parameters #name#weight…#1111111.111# and so on.

 

Trunc instead of pow?

 

Regards

 

Olaf

 

Von: firebird-support@yahoogroups.com <firebird-support@yahoogroups.com>
Gesendet: Freitag, 30. August 2019 10:04
An: firebird-support@yahoogroups.com
Betreff: Re: AW: [firebird-support] Converting with parameters stored in variables?

 

 

Hi,

 

You can do this simpler by using trunc.

 

But i ask why do you need this format in resultset? Formatting numbers is a client side task, same as for DATE.

 

 

Regards,

Karol Bieniaszewski