Information générale
Catégorie:
Codage, syntaxe et commandes
Titre:
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement