Error in tabel 18 Customer tabel.

Business Central/NAV Developers Forum
1

Dear All,

I created a new column in the Customer table, after a while I deleted it from the Customer table but through the SQL Server. now I tried to delete it from Navision but I always get an error which says:

0167.Untitled.png

I will go crazy to delte this field ! but I canot, I canot even compile the tabel due too this field.

Can anyone help me. (I am using Navision 2009 Classic client)

Thanks in Advance

2

Clearly that you should never do that. Haven’t done that myself, but the next thing I would do is recreate the column on SQL Server and then try again.

3

I did already, and when I create it enforce me to create the column with default null values. and this Couse another problem. so even if I create the field in SQL with allowing Null values Navision does not except it.

Any other ideas ?

4

I did already, and when I create it enforce me to create the column with default null values. and this Couse another problem. so even if I create the field in SQL with allowing Null values Navision does not except it.

Any other ideas ?

5

I did it!

1- I created the field again in the SQL server (right click/design/create the field WITH <DATETIME,not null>.

2- went to Navision tabel 18, compile it. then I delted the field manually.

Thanks,Zayed

6

Congrats.