Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 To: Tony Vignone
  Where is Tony Vignone?
 St Augustine
 Florida - United States
 Tony Vignone
 Tags
Subject: RE: Error Message: Line is too long
Thread ID: 393987 Message ID: 394105 # Views: 25 # Ratings: 0
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 30, 2013 6:01:43 PM         
   


> > Anyone run into this before?
> >
> > Here is the offending line of code:
> >
> > APPEND FROM (lcFilePathName) TYPE SDF
> > 

> > lcFilePathName translates to the following path:
> > K:\DATA\COMMON\FEED\IN
> >
> > I previously had a path that had a couple folders with spaces in their names, so I had put quotes around the path in the config file which held the paths. So, because I read that spaces in folder names cause problems I put the input file into a folder which had no spaces in its folder names. Same issue. Didn't change anything. Is this a FoxPro bug, or did I do something wrong?
> >
> > Cecil Champenois, Jr.
>
> Have you checked the input file? Is there a very long line in it?
>
> The help says "An SDF file is an ASCII text file in which records have a fixed length and end with a carriage return and line feed. Fields are not delimited"
>
> Tony

What I think I've discovered quite by accident is that the input path may have had two spaces in it for one or two folders. I re-typed the input path in the CONFIG file and when I reran the program, it ran just fine, with no errors. I think that in at least one of the folders, there may have been two spaces in between the first part of the folder name and the second part.

Cecil Champenois, Jr.

ENTIRE THREAD

Error Message: Line is too long Posted by Cecil Champenois @ 12/27/2013 8:02:35 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/27/2013 8:35:48 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/27/2013 8:53:54 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/27/2013 9:42:43 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/27/2013 9:51:23 PM
RE: Error Message: Line is too long Posted by David Mustakim @ 12/28/2013 12:29:31 AM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:20:39 AM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/28/2013 5:09:26 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:22:00 AM
RE: Error Message: Line is too long Posted by Pete Sass @ 12/28/2013 12:35:53 AM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:24:04 AM
RE: Error Message: Line is too long Posted by Pete Sass @ 12/30/2013 2:56:32 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:21:54 PM
RE: Error Message: Line is too long Posted by Pete Sass @ 12/30/2013 5:30:19 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 5:42:08 PM
RE: Error Message: Line is too long Posted by Stefan Wuebbe @ 12/27/2013 9:17:17 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 2:03:43 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/30/2013 2:14:05 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 2:17:13 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/30/2013 2:29:27 PM
RE: Error Message: Line is too long Posted by Stefan Wuebbe @ 12/30/2013 2:30:25 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/30/2013 3:00:24 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:11:24 PM
RE: Error Message: Line is too long Posted by Vivek Deodhar @ 12/30/2013 3:22:50 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:35:27 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/30/2013 3:39:06 PM
RE: Error Message: Line is too long Posted by David Mustakim @ 12/30/2013 3:40:34 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/30/2013 3:42:56 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:44:15 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/30/2013 3:47:20 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:49:18 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:42:54 PM
RE: Error Message: Line is too long Posted by Tore Bleken @ 12/30/2013 3:36:39 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 3:40:55 PM
RE: Error Message: Line is too long Posted by David Mustakim @ 12/30/2013 3:53:02 PM
RE: Error Message: Line is too long Posted by Tony Vignone @ 12/30/2013 5:53:15 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 6:01:43 PM
RE: Error Message: Line is too long Posted by Tony Vignone @ 12/30/2013 6:08:33 PM
RE: Error Message: Line is too long Posted by David Mustakim @ 12/30/2013 6:17:05 PM
RE: Error Message: Line is too long Posted by Cecil Champenois @ 12/30/2013 6:58:42 PM
RE: Error Message: Line is too long Posted by Tony Vignone @ 12/30/2013 6:52:22 PM