For our app, we have created a diagnostic export. The user runs this function and it uses the some of the low-level functions to write data to a text file, which is then encrypted and automatically e-mailed to us for troubleshooting purposes.

As part of the process we use 'copy to filename.txt delimited'. When we bring in the file at our end we use 'append from filename.txt delimited'.

It works just fine except for the datetime field. When we append records programatically, the datetime fields are blank, all others are fine. However, when I do this throught the VFP menu (table/append records/blah,blah,blah)- and append records to the very same table from the very same textfile - the datetime fields appear as they should. Anyone else come accross something like this? Any ideas on what I should change to make this work properly?