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

jfamvg

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:


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

EvR

NAV == weird!
I can only get it to accept booleans with datatype tinyint in SQL....
Tested with NAV 2017 CU6.

lubost

I think that this field contains NULL value, which is not supported in NAV.

EvR

Nope, non-nullable bit throws the same exception.