When creating new columns I want them to be NULL-able. There is an option ANSI NULL Default in New/Alter Database (SQL), but the columns are always created with NOT NULL. I have checked default settings on db, but nothing helps. What am I missing ? Now I go to EM and modify the columns there, but I would like to do it without this…
Navision always creates columns as NOT NULL regardless of this database setting for the default. This avoids countless problems with NULL semantics in queries, and NULL data handling. Quick quiz: Table ‘MyTable’ contains 1 text column allowing NULLs, with the following data: Field ----- ‘abc’ NULL What row(s) will be retrieved with the following queries: SELECT * FROM MyTable where Field = ‘abc’ SELECT * FROM MyTable where Field <> ‘abc’
my asumption 1. abc (1 row) 2. (0 rows) yes, you made your point. using nulls would probably complicate queries and slow them down significantly.