Microsoft KB Archive/105045

{| = FIX: APPEND FROM Returns the Year 768 =
 * width="100%"|

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.

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
 * }