Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending from SDF file
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00454166
Message ID:
00454174
Views:
25
>Hi,
>
>In my application users import a large ascii text files into the app. The app then slices and dices appropriately.
>
>I am using the command:
>
>APPEND FROM (gcImportZATM004) TYPE SDF
>
>where the value of gcImportZATM004 is "F:\ASTRA\FILES\ZATM004-13DEC"
>
>I get error # 1 and the message is:
>
>"File 'f:\astra\files\zatm004-13dec.txt' does not exist."
>
>Strange that although gcImportZATM004 did not have ".txt" included, the app was trying to import a file with a .txt extension - and when it couldn't find it - I of course got the error message.
>
>The app has been in daily use for a few months by a number of our credit unions - this is the first instance of this problem. The filenames normally used for importing are more like: "Assiniboine-90_ZATM004._19OCT2000" - these files work OK even though they don't have the .txt extension. Any idea as to why the app is trying to open "zatm004-13dec.txt" - when I want it to open "zatm004-13dec"?

APPEND FROM ... SDF assumes a TXT extension. If it's not, just put a period at the end of the file name as a means of specifying a file with no extension.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform