Error on creating a column

ckndr47

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.

lubost

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