Microsoft KB Archive/105045
FIX: APPEND FROM Returns the Year 768
2.00 MS-DOS kbprg kbfixlist kbbuglist
The information in this article applies to:
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.
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.
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.
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:
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