Export Data to a File Weirdness

DataDoIt filepro at datadoit.com
Wed Apr 6 11:32:56 PDT 2005


fPODBC v1 on Win2k3 Server;

I have created a simple export routine that compiles data into a variable,
then:

SYSTEM "ECHO " & variable & " >> file.csv"

All is well when developing this and testing, but doesn't work in
production.  The difference?  Development is on the same machine under
c:\development\filepro, and production is the normal c:\filepro.  The fP
stuff is under c:\fp for which both development and production share.

In the development version of the data, the export works perfectly.  The
order of events are:

1. Deletes the file that's already there using:
   SYSTEM "DEL file.csv"

2. Exports out a header routine that sends out the column headers using:
   SYSTEM "ECHO " & header & " >> file.csv"

3. Finally exports out the data using the above.

On production, it'll remove the file okay.  It'll write the header info
okay, but won't write the data.  I've verified that there's data in the
variable.  What in the world could this be?  The only difference is filePro
data folder on the same machine.

Thanks.

-MikeR



More information about the Filepro-list mailing list