hi,
CREATE table cImprt (Fld1 C(10), fld2 C(10), fld3 C(10), fld4 C(10), fld5 C(10))
cParseChar = CHR(13)+CHR(10)
my_txt = FILETOSTR("ala")
all_lines = ALINES(txtLines, my_txt, cParseChar)
WAIT WINDOW all_lines && To check how many lines ALINES() returns
***i can see 5 records, yes this is my table
**when browse i see one record
SELECT cImprt
currentField = 0
FOR i = 1 TO all_lines
currentField = currentField + 1
IF currentField > 5
currentField = 1
ENDIF
IF currentField == 1
INSERT INTO cImprt (Fld1) VALUES (txtLines[i])
ELSE
fldname = FIELD(i, "cImprt")
REPLACE &fldname WITH txtLines[i]
ENDIF
ENDFOR
GO TOP
brow
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only