Skip to Content

How to change a data type in a graphical calculation view

How do I change the data type of a calculation view?

Background: we do comparison tests with DbUnit. DbUnit requires the data-types to be exactly the same.

So I need to change for example from BigInt to Int.
SQL equivalent: cast(colName as integer)

(I do see the data-type in the properties window of a column. But do not see any option to change it)

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 23, 2017 at 07:34 AM

    Hi Thorsten,

    I think you only can do this with a (new) calculated column for each field:

    Best Regards

    Thorsten

    Add comment
    10|10000 characters needed characters exceeded