Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Line too long
Message
 
To
17/05/2014 18:43:59
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01600160
Message ID:
01600162
Views:
54
I tried your suggestion. The first record says raises the error. When I hit ignore, I can then browse the table, the first record contains the line "this line is ok ..." There
is no second or third record.

On the other hand, I can add a memo field to my table, then use the following to append the htm file into the table. The following adds the htm file into the memo.
From what you are saying, I guess one of the lines must indeed be very long.

APPEND BLANK
GO bott
APPEND MEMO hmemo FROM intc_rt.htm

How could I parse each "line" from the memo into the hline field?
Thank you,
Steve

>Can you check the input file? It must not have line lengths exceeding VFP internal limit (approximately 64KB). The following code reproduces the error (respond with "Ignore" to see the result):
>
>CREATE CURSOR curTable (hline C(239))
>STRTOFILE("This line is ok, the next will raise an error message" + CHR(13) + REPLICATE("*",64*1024),"myfile.htm")
>APPEND FROM myfile.htm TYPE sdf
>BROWSE
>
>
>>Hello,
>>I have a file called: "myfile.htm." And a have a table with one field, called "hline," with 239 characters.
>>When I try this command:
>>
>>
>>APPEND FROM myfile.htm TYPE SDF
>>
>>
>>I get this error message: "line too long"
>>
>>I have used this append command many times. It just cuts off lines that are too long. I wonder why I am suddenly getting this message.
>>
>>Thank you,
>>Steve
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform