best method to prevent null attribute values

Question

Hello all,

We have several feature attributes that require values and are using different methods to enforce population: contingent values, attribute rules, and the "allow null" check box on the attribute itself.

In order to enforce population, what would be the best practice method of the above options? This attribute is not related to other attributes, not a network attribute (we use a utility network model), and not dependant on sub-type.

My initial thought was the simplest method would be to de-select the "null allowed" field on the attribute itself. Any other consequence of that method?

Thanks,

joecastellana · Answer

Good info there, thanks for sharing.

joecastellana · Answer

Thanks all, I'll go with a contingent value in this case as we've used that solution on another field so at least it will be consistent.

Robert LeClair · Answer

If you're using an Enterprise geodatabase, you can use a NOT NULL constraint on the field(s) of interest.  You can learn the SQL code to do this here.