not null

[Dan @BCBS]

I added a field to a table but the field needs to be required.
The table is ODBC linked to an SQL table.
So, when I try to make the field required in SQL it cannot, because the new
field is null for every record.

How can I populate all 30 thousand records with a value. Also, the field is
a date field.

Once I have a value in every record I can make the field manditory (Not Null).

 

[pietlinden]

I added a field to a table but the field needs to be required.
The table is ODBC linked to an SQL table.
So, when I try to make the field required in SQL it cannot, because the new
field is  null for every record.

How can I populate all 30 thousand records with a value. Also, the field is
a date field.

Once I have a value in every record I can make the field manditory (Not Null).

you would have to update the table with some value. Then the Not Null
constraint will be valid. The problem I see is a logical one.... how
do you determine what date is a placeholder for null?