Microsoft KB Archive/99905

{|
 * width="100%"|

-

The information in this article applies to:


 * Microsoft FoxPro for MS-DOS, versions 2.5x, 2.6x
 * Microsoft FoxPro for Windows, versions 2.5x, 2.6x
 * Microsoft FoxPro for Macintosh, versions 2.5x, 2.6x

-

SYMPTOMS
A &quot;Line too Long&quot; error message will appear when you try to append records containing more than 3998 characters. This was the previous character limit in FoxPro version 2.0 for MS-DOS.

STATUS
Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article. This problem was corrected in Visual FoxPro 3.0 for Windows.

MORE INFORMATION
In FoxPro 2.6a for MS-DOS, this error does not occur when using a tab delimited or comma delimited file. This error only occurs when using an System Data Format (SDF) file.

Steps to Reproduce Problem
 Create a database of 20 fields with 200 characters each. Call the database REALBIG. The total number of characters per record should be 4001. Add one record.  Type the following in the Command window       USE REALBIG and then type:       COPY TO REALBIG1 TYPE SDF The file should be copied without error.   Type the following in the Command window:       APPEND FROM REALBIG1 TYPE SDF The error message &quot;Line too long&quot; will appear.   Type the following in the Command window:       MODIFY STRUCTURE  Change the last field's character length to 197. Make the changes permanent.</li> Repeat step 3. Again, the file will copy without error.</li></ol>

Additional query words: FoxMac FoxDos FoxWin VFoxWin fixlist3.00 buglist2.50 buglist2.50a buglist2.50b buglist2.50c buglist2.60 buglist2.60a 2.50 2.50a 2.50b 2.50c 2.60 2.60a errmsg err msg

Keywords         : kberrmsg FxprgTable Version          : 2.5x 2.6x | 2.5x 2.6x | 2.5x 2.6 Platform         : MACINTOSH MS-DOS WINDOWS Issue type       :
 * }