FIX: Append Type SDF into Local View Does Not Update Base Table (195511)

MORE INFORMATION

Steps to Reproduce Behavior

1. Using the following step to create a table, named mytable:

         CREATE TABLE mytable (name1 c(10), num n(5))
         INSERT INTO mytable VALUES ("test1",1)
         INSERT INTO mytable VALUES ("test2",2)
         INSERT INTO mytable VALUES ("test3",3)
         INSERT INTO mytable VALUES ("test4",4)
   							

2. Once you create the preceding table, use the following command to create a type SDF file:

         COPY TO mysdf.txt TYPE SDF
   							

3. Next, create a database, named data1.
4. Add mytable to the data1 database.
5. Create a local view based on mytable.
6. In the View Designer, click the Fields tab, and then add all the Available fields to the Selected fields column.
7. Click the Update Criteria tab, and select the key column next to the name1 field and select the pencil column next to both the name1 and num fields. Make sure you also select the 'Send SQL updates' check box.
8. Save the local view as view2.
9. In the Command window, while the database designer is still open, type the following commands:

         USE view2
         APPEND FROM mysdf.txt TYPE SDF
         BROWSE
   							

   At this point, five records from the mysdf.txt have been appended to view2.
10. Now, in the Command window, type in the following commands:

          SELECT mytable
          BROWSE