Hi Andreas,
First, there's SCAN command for looping thru table/cursor.
Second, you can use parameters in SQLEXEC. This way it wouldn't be affected by the size of the data.
SCAN
ta_hdr =ALLTRIM(LEFT(ta_header,160))
TCode = ...
Tseq = ...
=SQLEXEC(sqlHandle,"INSERT INTO TAPOUT_DETAIL_CALL_TABLE " + ;
"(TA_RECORDS, TA_PLMNS, TA_SEQUENCES) VALUES (?ta_hdr, ?TCode, ?Tseq)")
ENDSCAN
>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.
--sb--