FIX: APPEND FROM Returns the Year 768

The information in this article applies to:

• Microsoft FoxPro for MS-DOS, version 2.0

SYMPTOMS

When you are using an APPEND FROM command to append an ASCII file to a database file that contains two date fields in a row, the year 768 will be put in the second field if the ASCII file does not contain information for that field.

RESOLUTION

Insert two forward slashes (//) between the delimiters, or arrange the order of the fields so that no two date fields are next to each other.

STATUS

Microsoft has confirmed this to be a problem in FoxPro 2.5 for MS-DOS. This problem was corrected in the FoxPro 2.5 for MS-DOS.

MORE INFORMATION

Steps to Reproduce Problem

1. Create DATE.DBF with the following structure and format:

         Field name    Type         Size
         -------------------------------
   
         date1         Date           8
         date2         Date           8
         fname         Character     10
   
   

2. Create a file called DATE.TXT with the following information in it:

         19920315,19930915,"TOM"
         19900606,,"SALLY"
   

3. Issue the following commands:

         USE date
         APPEND FROM date.txt TYPE DELIMITED
         BROWSE NOWAIT
         x=YEAR(date2)
         WAIT WINDOW STR(x)