FIX: APPEND FROM Returns the Year 768ID: Q105045 2.00 MS-DOS kbprg kbfixlist kbbuglist The information in this article applies to:
SYMPTOMSWhen 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. RESOLUTIONInsert two forward slashes (//) between the delimiters, or arrange the order of the fields so that no two date fields are next to each other. STATUSMicrosoft 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 INFORMATIONSteps to Reproduce Problem1. 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 |