Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
APPEND FROM problems
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00407143
Message ID:
00407186
Views:
24
Kenneth,
I tried your code with a sample table and text file and it worked just fine. Is there a possibility that you have the wrong table selected in your form? Or that there are triggers or other code in the DBC that is affecting the append?

HTH
Barbara

>I am trying to append records to a table from a text file using the following code:
>
>LOCAL lcFile
>lcFile = ALLTRIM(LOCFILE("Inventory.txt","TXT","Select the inventory file."))
>APPEND FROM &lcFile TYPE DELIMITED WITH TAB
>
>The APPEND FROM generates an error 36, "Command contains unrecognized phrase/keyword." I have read about issues concerning APPEND FROM and certain types of files, but thought they had been resolved in Service Pack 3. I'm using sp4. This command worked in Fox 2.6. I have tried replacing &lcFile with (lcFile) and I get the same error. Anyone have any ideas or a workaround? Thanks.
Barbara Paltiel, Paltiel Inc.
Previous
Reply
Map
View

Click here to load this message in the networking platform