Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Macro Expansion
Message
From
09/01/2002 08:51:33
 
 
To
09/01/2002 07:59:47
John Marrone
Bloodstock Research Inc.
Lexington, Kentucky, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00602412
Message ID:
00602455
Views:
57
>I did use alines, and it works fine 95% of the time. Its the 5% of the
>time that is killing me. For some reason about every 20th record it loses
>a field or two. I don't know if it is because each record has so many fields
>in it (1435). Here the code using Alines().
>
>DIMENSION aAr(1435)
>vcStr = FGETS(nHandle, 8192)
>vnRecCnt = ALINES(aAr, CHRTRAN(CHRTRAN(vcStr, ["], ""), ",", CHR(13)))
>
>This will work but then it just messes up after so many records?? Plus ALines()
>makes every element a string, so u have to use VAL() to store it as a numeric.

What I found when I was trying to do similar, using chrtran replaces ,, with 2 newlines, which alines ignores - hence my suggestion of strtran to insert the additional space.

Is it possible to create the table with the correct type fields & use APPEND FROM ?
Len Speed
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform