Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Line too long
Message
 
À
17/05/2014 18:43:59
Antonio Lopes (En ligne)
BookMARC
Coimbra, Portugal
Information générale
Forum:
Visual FoxPro
Catégorie:
Codage, syntaxe et commandes
Titre:
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows 7
Network:
Windows 2008 Server
Database:
Visual FoxPro
Application:
Desktop
Divers
Thread ID:
01600160
Message ID:
01600162
Vues:
53
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
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform