PRB: All New Field Values Set to .NULL. When You Modify Table

MORE INFORMATION

Steps to Reproduce Behavior

1. From the Command window, issue the following commands:

      SET NULL ON
      CREATE DATABASE mydata
      CREATE TABLE mytable (cFld1 C(20))
      APPEND BLANK
      REPLACE cFld1 WITH "Hello"
      BROWSE
   						

2. Browse the table to view the first record, and note the table structure. Then modify the table with an ALTER TABLE command:

      ALTER TABLE mytable ADD COLUMN cNewfld C(20)
      BROWSE
   						

Now the field value for cNewfld holds the value .NULL..

NOTE: Placing NOT NULL at the end of the ALTER TABLE command doesn't work if SET NULL is ON. Instead, the error message "Field NEWFLD does not accept null values" is displayed, and the field is not added.