Conversion character to integer

[Former Member]

Hi all,

I'm building a Calculation View based on SQL Scripting. Within this Calculation View I try to use the CE-functions as much as possble.

One of the challenges is the conversion of a character field (containing numbers) to something like an integer.

So, is there a way of doing that within a Calculation View?

Using conversion functions the validation is always okay, but running the view always leads to errors (mentioning that the data type for a specific function is wrong).

Any ideas?

Thanks!

Grz,

Stefan

[Former Member]

Hi Rijinkels,

Could you provide error evidence for detail information, besides, whether you use to_int function to do convert character to int?

Regards,

Jerry