Microsoft KB Archive/195511

= FIX: Append Type SDF into Local View Does Not Update Base Table =

Article ID: 195511

Article Last Modified on 5/12/2003

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 3.0b Standard Edition
 * Microsoft Visual FoxPro 5.0 Standard Edition
 * Microsoft Visual FoxPro 5.0a
 * Microsoft Visual FoxPro 6.0 Professional Edition

-



This article was previously published under Q195511



SYMPTOMS
When using the APPEND FROM command to append a TYPE System Data Format (SDF) format file that contains numeric value into a local view, the numeric value shows in the local view but does not get updated into the base table.



STATUS
Microsoft has confirmed this to be a bug in the Microsoft products listed at the beginning of this article. This bug has been corrected in Visual FoxPro 6.0.



Steps to Reproduce Behavior
  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)   Once you create the preceding table, use the following command to create a type SDF file: COPY TO mysdf.txt TYPE SDF  Next, create a database, named data1. Add mytable to the data1 database. Create a local view based on mytable. In the View Designer, click the Fields tab, and then add all the Available fields to the Selected fields column.</li> 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.</li> Save the local view as view2.</li>  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. </li>  Now, in the Command window, type in the following commands: SELECT mytable BROWSE </li></ol>

NOTE: The character data for the last five records has been appended to the base table, but the numeric data is missing from the base table.

Keywords: kbbug kbfix kbvfp600fix kbdatabase KB195511

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.