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