Options

Error on creating a column

ckndr47ckndr47 Member Posts: 100
Hi,

I am creating a column in my Navision DB table but it is not allowing me to create any column. I am getting this error message
The <FIELD_NAME> field on the <TABLE_NAME> table does not exist in the SQL Server table or view.

I m using navision with MS SQL Server integration.

Thanks in advance.

Comments

  • Options
    lubostlubost Member Posts: 618
    1. You have to set your SQL permissions to DB_OWNER
    2. You have to use field numbers from range 50000-99999 (in standard NAV tables).
    3. You can't insert code in triggers before table with new field is compiled
Sign In or Register to comment.