Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Appending from SDF file
Message
From
15/12/2000 15:00:57
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
00454166
Message ID:
00454179
Views:
19
If no file extension is included, it APPEND FROM (and COPY TO fyi) defaults to certain extensions based on the type (SDF-->TXT, e.g.)
Are you sure that the variable doesn't contain the actual extension when it works?
Don't know how you're populating the file variable, but if you use GETFILE() you'll get the full path, with extension. In that case, it should always work fine.

>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"?
Insanity: Doing the same thing over and over and expecting different results.
Previous
Reply
Map
View

Click here to load this message in the networking platform