web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / Bit datatype problem I...
Microsoft Dynamics NAV (Archived)

Bit datatype problem In Navision

(0) ShareShare
ReportReport
Posted on by NavTech 2,390

I am trying to connect sql table with Navision using view . But the fields defined as bit are not supported.

I Have tried with boolean and option also. no success

Microsoft Dynamics NAV
---------------------------

Table content in the Sell_online table on SQL Server contains a value that is not compatible with the corresponding data type that is defined for the table.

Field: UserEnabled
Type: Integer
SQL type: bit

The table design may have been changed outside Microsoft Dynamics NAV.

Page Edit - Sell_online must close.
---------------------------
OK
---------------------------

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Hi

    Every NAV data Type is mapped to an appropriate SQL Server data type in the tables of the SQL Server Option for Microsoft Dynamics NAV

    refer the below link for the same and change the data Type of the field to the appropriate data Type In NAV

    https://msdn.microsoft.com/en-us/library/dd338650.aspx

    Regards

    Rajasekhar.Y

  • NavTech Profile Picture
    NavTech 2,390 on at

    That list is for Nav 2009 .It's working fine in 2009 but not in 2015

  • Rajasekhar@MS Profile Picture
    Rajasekhar@MS 5,569 on at

    Could you let us know what the values will be for the field, if it is Yes or No can you check with the Boolean data Type in Navision

  • Verified answer
    keoma Profile Picture
    keoma 32,729 on at

    change the sql view. assume the bit field is called YesNo. use following expression instead of the YesNo field in the select statement of the view: convert(tinyint,YesNo) as YesNoAsBool.

    with this change you can use datatype boolean in your nav table. change the field name YesNo in the nav table to YesNoAsBool.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans