not null

  • Thread starter Thread starter Dan @BCBS
  • Start date Start date
D

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).
 
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).
Click to expand...

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?
 
Back
Top