Modify a boolean field in NAV database by TSQL

Comments

• DenSter Member Posts: 8,307

  2015-07-23

  Do you mean changing the data type of the field itself or changing the value of the field? Any changes to the table definition (fields, keys) should never be done on SQL Server but in the table designer in C/SIDE. You can change field values directly on SQL Server, as long as those values are formatted in a way that NAV understands. Code type fields for instance are Varchar fields on SQL Server, and they are all caps. When you insert lower case values, NAV might not understand. The only other thing you need to worry about is null values. NAV does not understand null values, so you need to make sure all field values have values, even if they are blank (null is not the same as an empty string '').

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0
• lvanvugt Member Posts: 774

  2015-07-24

  And of course ... changing values through TSQL is not going to execute any business logic related to the field you are changing the value of.

  Luc van Vugt, fluxxus.nl
  Never stop learning
  Van Vugt's dynamiXs
  Dutch Dynamics Community

  0
• DenSter Member Posts: 8,307

  2015-07-24

  Yes very important Luc, thanks for the reminder

  Daniel Rimmelzwaan
  RIS Plus, LLC

  0
• winderman66 Member Posts: 11

  2015-07-24

  Yes, its only the values.
  
  Thanks for the explanation guys, its very appreciated for a NAV beginner like me.

  0