Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Command contains unrecognized phrase/keyword.
Message
From
06/11/2001 20:55:42
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Command contains unrecognized phrase/keyword.
Miscellaneous
Thread ID:
00578321
Message ID:
00578321
Views:
132
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
Map
View

Click here to load this message in the networking platform