FIX: APPEND FROM Returns the Year 768

Last reviewed: October 14, 1997
Article ID: Q105045
2.00 MS-DOS kbprg kbfixlist kbbuglist

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)
    


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


THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.

Last reviewed: October 14, 1997
© 1998 Microsoft Corporation. All rights reserved. Terms of Use.