NAV 2016 TableType ExternalSQL error mapping the sql type 'bit' to an NAV type

jfamvg
jfamvg Member Posts: 1
edited 2017-05-16 in NAV Three Tier
Hello,

I am trying to map an external table in NAV with the ExternalSQL table type (following: http://larswestman.se/tabletypeexternalsql/).
This is working fine until I tried to map a bit field (SQL Type), I tried mapping it to a boolean, integer and text. All mappings resulted
in the following error:
2axr793bsu9j.png

Does anyone know how to map this SQL type in NAV?
Thanks in advance!

Answers

  • EvR
    EvR Member Posts: 178
    edited 2017-05-17
    NAV == weird!
    I can only get it to accept booleans with datatype tinyint in SQL.... :(
    Tested with NAV 2017 CU6.
  • lubost
    lubost Member Posts: 633
    I think that this field contains NULL value, which is not supported in NAV.
  • EvR
    EvR Member Posts: 178
    Nope, non-nullable bit throws the same exception.

Categories