New Column not showing in navision

palan · 2011-02-01

HI,

I am using Navision 3.6 version with SQL 2008 db, i have added few columns to an existing table using SQL.

SQL DBA has run the alter table command and added the columns and when i try to view the table I am not able to view it & when i try to insert the same column name in navision getting the below error. Can someone help on this error. Thanks.

Microsoft Navision Attain

The following SQL Server error(s) occurred while accessing the Sales Header table:

2705,"42S21",[Microsoft][ODBC SQL Server Driver][SQL Server]Column names in each table must be unique. Column name 'Consumer' in table 'consumer.dbo.customer$master Header' is specified more than once.

OK

Luc_VanDyck · 2011-02-01

You should add the columns through the NAV Object Designer, not through SQL.

palan · 2011-02-01

I am not having administrator rights to add the column in the staging database hence need to request the DBA to add the columns using SQL commands.

In Development database i have added using Navision object designer and it is working fine.

Any suggestion to solve?

kine · 2011-02-01

palan wrote:

I am not having administrator rights to add the column in the staging database hence need to request the DBA to add the columns using SQL commands.

In Development database i have added using Navision object designer and it is working fine.

Any suggestion to solve?

You cannot "solve" the permission problem by creating the columns on SQL and than trying to solve "I cannot see them in NAV". The primary problem is the permissions. Solve this, add the columns in standard way. There is no "way around".

kriki · 2011-02-17

NAV 3.6 on SQL 2008????? :shock: :? #-o

I suppose it has been technically upgraded.

New Column not showing in navision

Comments

Categories