Hoi Walter,

Het gaat redelijk. En met jou?

It is now a real issue because the company is implementing a more recent version of SQL Server and its import routine no longer accepts single double quotes whereas the previous version did. That the former version did accept it, is something we didn't know at that time. Else, we'd have seen this behavior long time ago and acted upon it. Nowadays there are many interfaces that are done using CSV, so it's not a simple repair.

Here's an extended version of my 'proof'. The 3rd record shows that vfp does not handle double double quotes properly.

create cursor c_effe ( txt c(20) )
insert into c_effe value ( 'is weer "ziek"' )
copy to effe type csv
append from effe type csv
strtofile( 'txt'+chr(13)+chr(10)+'"is weer ""ziek"""', 'effe1.csv' )
append from effe1 type csv
browse

Is your csv generator fast and generic?

>Hoi Peter,
>
>Hoe gaat ie?
>
>For this (and other) reasons, we just build our own CSV generator, but it was after the release of V9 and did not found it to be a big enough problem to put it on the ER list.
>
>Walter,
>
>
>
>
>>I'm amazed that nobody here has EVER in the past decade made a comment about this incorrect behavior. There are several posts about the problem, but never it was said that it's a bug, including your posts.
>>
>>It is important for developers to be aware of the incorrect behavior, because it makes it a requirement to do no direct COPY TO TYPE CSV or APPEND FROM TYPE CSV. Instead, one should write a bug-aware function that does create or read.
>>
>>>And your point is?
>>>
>>>>IMO, VFP, including 9, has a bug with regard to the export and import of CSV-files.
>>>>
>>>>Here is the code that proves this:
>>>>

create cursor c_effe ( txt c(20) )
>>>>insert into c_effe value ( 'is weer "ziek"' )
>>>>copy to effe type csv
>>>>append from effe type csv
>>>>browse

>>>>
>>>>How come nobody ever told this to the vfp-team???
>>>>
>>>>And yes, I know how to prevent this. But isn't that actually a silly situation? It should've been VFP that does the correct handling of double quotes.
>>>>
>>>>See also: http://en.wikipedia.org/wiki/Comma-separated_values and http://tools.ietf.org/html/rfc4180