Changing a field to Not Null

[jrsitman]

Is it possible or safe to change an existing field that has data to "Not Null"?



Thanks,

[pbaldy]

You won't be able to do it if there are records with that field Null, but otherwise it's doable.

[Welshgasman]

Why not just test for Null?

[jrsitman]

To be clear you're stating the field cannot have any empty data. I'll run a query to see how many not null there are

[jrsitman]

I just ran the query and the field has data in every record. So I can change the status to "Not Null" to force them to enter data, correct?

[pbaldy]

I would say so, yes, but I work primarily with SQL Server back ends.

To WGM's point, I would test for Null, but from a "belt and suspenders" point of view, I will also set the field to not allow nulls when appropriate.

[jrsitman]

Thanks. We don't want any nulls. I'll try it.