FIX: APPEND FROM Returns the Year 768

ID: Q105045

2.00 MS-DOS kbprg kbfixlist kbbuglist

The information in this article applies to:

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)

Additional reference words: FoxDos 2.00 buglist2.00 fixlist2.50 commas tabs KBCategory: kbprg kbfixlist kbbuglist KBSubcategory: Solution Type : kbfix

Last Reviewed: October 14, 1997