General information
Category:
Coding, syntax & commands
Title:
Command contains unrecognized phrase/keyword.
Dear All,
I am having a problem when uploading text file into oracle with VFP:
The data file:(STRING)
10XXXXXYYYYY00214Y10000000000000000000000000000000 010901010901010901114640+070002001 008 62
12A00001256990 00000000000 00000000000 00000000000 00000000000 00000000000 00000000000 00000000000 00000000000 00000000000
14A+0700
20 510001000010864 0XX0218412438 011 10 120000
20 510001000008372 0XX0227235825 011 10 120000
..
..
The code:
FOR tUpl=1 TO RECCOUNT()
GO tUpl
ta_hdr=ALLTRIM(SUBSTR(ta_header,1,160))
=SQLEXEC(sqlHandle,"INSERT INTO TAPOUT_DETAIL_CALL_TABLE (TA_RECORDS,; TA_PLMNS, TA_SEQUENCES)VALUES ('&ta_hdr', '&TCode', '&Tseq')")
ENDFOR
The code will succesfully proccesed record 1-3 but when on record 4 the upload procces will stop with the error message "COMMAND CONTAINS UNRECOGNIZED PHRASE/KEYWORD".
anyone can help me with this.
Thanks,
Andreas.
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