Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Pete Sass
  Where is Pete Sass?
 Marathon, Ontario
 Canada
 Pete Sass
 To: Cecil Champenois
  Where is Cecil Champenois?
 Little Elm
 Texas - United States
 Cecil Champenois
 Tags
Subject: RE: Error Message: Line is too long
Thread ID: 393987 Message ID: 394102 # Views: 24 # Ratings: 1
Version: Visual FoxPro 9 SP2 Category: Databases, Tables and SQL Server
Date: Monday, December 30, 2013 5:30:19 PM         
   


> >
> >
> > Hi,
> > Ok here is I think something for you to do and maybe will shed light on your issue.
> >
> > I first created a folder structure 100% identical to yours on my server under an S:\ drive.
> >
> > So my path is "S:\Common\Shared Data\Trans America\IN"
> > I next created a txt file with the same name as yours . . "Coverages_20131127.TXT"
> > I added one line in the txt file with word "Hi there, this is working"
> >
> > I then went into the VFP command window and performed the following commands . .
> >
CREATE CURSOR curTest (Data C(28))
> > inputPolicyDataPath = "G:\Common\Shared Data\Trans America\IN"
> > SET DEFAULT TO (inputPolicyDataPath)  && This is not required, just to verify if I can set a default into your folder path.
> > inputPolicyDataPath = inputPolicyDataPath + "\Coverages_20131127.TXT"
> > APPEND FROM (inputPolicyDataPath) TYPE SDF

> >
> > After running the Append From command several times here is what I see in my temp cursor:
> >
> >
> > Now the difference is I just used the inputPolicyDataPath memory variable instead of the one you used
> > which in my test will make no difference providing your memory variable has the same string value in it.
> >
> > I strongly suggest now with not resolving this you move into the VFP command window and duplicate
> > my test above. This will prove the validity of the .txt file and also 100% prove that on your
> > system this is working.
> >
> > After this has been done, now dive into your code and see what values do not match what you already
> > proved worked in the command window.
> >
> > Of course if failing in the command window, the problem is not with FoxPro. We can look at this
> > if in the command window things fail... but I think is will be OK in the command window and you
> > have something wrong in code logic.
> >
> > Pete "the IceMan", from the Great White North of Canada.
> > www.marathongriffincomputers.com
>
> Okay, here's what is in the CONFIG file, which has a file extension of CFG. For some odd reason, this is working now. I am wondering if maybe the path which had spaces in it might have been at odds if I "accidentally" typed an extra space, making two spaces in the path for the memvar (property) inputPolicyDataPath. I wonder if this might have caused the issue? Sometimes one and two spaces could appear the same to the eye. I re-typed the entire path and then put quotes around it. We have a CLASS which turns the memvars in the CONFIG file into properties, so that dataPath becomes a property, and so on for the other memvars.
>
>
> dataPath = K:\<font color="Blue">DATA\PASS\DB;K:\<font color="Blue">DATA\COMMON\DB
> tempPath = K:\<font color="Blue">DATA\TEMP
> logPath = k:\<font color="Blue">APP\COMMON\AUTOMATED\<font color="Blue">LOG
> outputPath = k:\<font color="Blue">DATA\COMMON\FEED\OUT
> inputPolicyDataPath="G:\Common\Shared Data\Trans America\In"
> 

>
> Cecil Champenois, Jr.


Hi,
I am sure that something like what you mention was the root cause.
One extra space would in fact kill it for you. Likewise a non-visible chr()
character embedded in the string could also kill the code.
Glad it is now working!
Pete "the IceMan", from the Great White North of Canada.
www.marathongriffincomputers.com

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