Skip to main content

    Issues

    New

    Table.AddColumn may display invalid data (out of range) in Query Editor

    Vote (1) Share
    Marcel Beugelsdijk's profile image

    Marcel Beugelsdijk on 14 Sep 2016 12:46:44

    If you supply a Column.Type with Table.AddColumn (e.g. Byte.Type), then the Query Editor will also display values that are out of range for the Data Type.
    E.g. for Data Type Byte, values >255 are still displayed in the Query Editor, but they won't load to the table when the query is applied.
    This differs from Table.TransformColumnTypes which will result in an Expression.Error when data is out of range.

    Comments (1)
    Marcel Beugelsdijk's profile image Profile Picture

    Marcel Beugelsdijk on 05 Jul 2020 22:38:40

    RE: Table.AddColumn may display invalid data (out of range) in Query Editor

    The same issue may occur when a type is supplied as the fourth parameter of Table.DuplicateColumn.