>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?
Have you looked at what the text is for the date/time field? Unlike the a date field where the data is stored as a string in the format YYYYMMDD, a date/time value is probably stored in the same format a a FILETIME structure (2 DWORDS), since it, like the FILETIME structure are 8 bytes. If the text is in a readable date time format that can be converted using the CTOT() function, it's probably the easiest way and your best bet.
George
Ubi caritas et amor, deus ibi est