>This seems to be a definite bug in VFP7.
>If you have a table and copy records out to a CSV file using the CSV sub clause, and then subsequently APPEND FROM
CSV the dates will be incorrect. I cannot find any way to append dates correctly using the CSV clause.
>I know I can import using DELIMITED clause and then remove the first record as a work around but it would be nice if the command s in the language actually worked.
>Does anyone know if Microsoft is aware of this issue?
Sam,
Yes they're aware. From my POV this doesn't go into bug list but yes MS accepted as a bug.
Why I don't accept as a bug :
-A CSV file is a delimited file with the exception first line contains fieldnames.
-There is no command to import a csv file in fact. There is only 'append from...type csv'.
-'Append from ... type csv' is different from 'append from ... delimited' only it does ignore the first line. It doesn't use first line at all and thus is actually a command that shouldn't exist (or misnamed). The higher priority bug is that IMHO.
Simply doing a 'append from ... delimited' and deleting first record is a way to get dates correct. But to get fields to their corresponding fields if field ordinals do not match is much harder.
If besides correcting date issue, field names would be taken into account then I'd accept it 'working correct' and would like it to be corrected too :)
Cetin