program error - line too long

program error - line too long

Post by Pacomiag » Tue, 02 Mar 1999 04:00:00



help
I have had a foxpro application tossed on me 4 days ago.  the application ran
fine under Windows 3.1 but after switching to Windows 95 I get a program error
is the following line>
  APPEND FROM arcust.a01 TYPE DELIMITED

THANKS
MATT RIVERA

please email thanks

 
 
 

program error - line too long

Post by Paul Borowic » Tue, 02 Mar 1999 04:00:00


Does this KB article apply to your situation?

http://support.microsoft.com/support/kb/articles/q99/9/05.asp

HTH,

--Paul

FIX: "Line Too Long" Error When Appending Records
2.5x 2.6x | 2.5x 2.6x | 2.5x 2.60a
MS-DOS    | WINDOWS   | MACINTOSH

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, version 2.5x, 2.6x

SYMPTOMS
A "Line too Long" 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 "Line too long" will appear.

Type the following in the Command window:

      MODIFY STRUCTURE

Change the last field's character length to 197. Make the changes permanent.

Repeat step 3.
Again, the file will copy without error.


>help
>I have had a foxpro application tossed on me 4 days ago.  the application
ran
>fine under Windows 3.1 but after switching to Windows 95 I get a program
error
>is the following line>
>  APPEND FROM arcust.a01 TYPE DELIMITED

>THANKS
>MATT RIVERA

>please email thanks


 
 
 

1. fold a long line into short lines, how ?

[ Article crossposted from comp.os.ms-windows.nt.misc ]
[ Author was Kuo-Chien Kai ]
[ Posted on 10 Apr 1995 18:14:34 GMT ]

In MS SQL Server, I have a table named my_tab which contains 2 columns:
      col1: 30-char long  
      col2: 120-char long

If I execute 'isql -U sa -P mypass -D mydb -Q "select * from my_tab"'
from the command prompt on NT, each output line will cross lines. I
wish the output can be prepared in either way of the followings. Is this
possible ?

(1) col1                         col2
    ---------------------        -------------------------
    this is row1 of col1         this is row1 of col2, and
                                 this is a very long long
                                 long row .........
    this is row2 of col1         this is row2 of col2, and
                                 this is a very long long
                                 long row .........

(2)
    this is row1 of col1        
    this is row1 of col2, and
    this is a very long long
    long row .........
                             <- a blank line, used as a record separator
    this is row2 of col1        
    this is row2 of col2, and
    this is a very long long
    long row .........

BTW, I have to execute isql from the command prompt, I don't want to
use  isql/w or any SQL client tools.

---
Best Regards,

Kuo-Chien Kai
----------------------------------------------------------------

National Tsing Hua University   |  Phone: +886-35-715131-5160
Hsinchu, Taiwan 30043           |    Fax: +886-35-710776

--
---
Best Regards,

Kuo-Chien Kai
----------------------------------------------------------------

National Tsing Hua University   |  Phone: +886-35-715131-5160
Hsinchu, Taiwan 30043           |    Fax: +886-35-710776

2. Statistic Functions available from Sybase?

3. Different CodePages

4. Des2k Problem: Line too long error when generating Forms w/ COMPLEX calls

5. System Tablespace gone mad!

6. ESQL/C: Error -33020: Line is too long.

7. Universe currency question

8. NewEra2.12: LINK: error line too long

9. "Line too long to fit" Error

10. My 2-line program gives an error, HEEEELP !

11. How to output error from command line program