>Hello,
>
>We're having trouble saving something like "Mike's Pizza" using a remote view on a SQL 7.0 data source.
>
>I guess VFP is sending it as: 'Mike's Pizza' and confusing the 3 single quotes. Can we not instruct VFP to use DOUBLE-QUOTES around its SQL calls ?
>
>We had a work-around on a different project that used SQL pass-through.
>
>This project uses mostly Remote Views and we seem to have much less control in this case.
>
>Any help would be greatly appreciated.
>
>Henry

If the ODBC connection has Quoted Identifiers on, then single quotes must be used or anything with double-quotes around it will be looked at as a column name. So, the ODBC connection uses single quotes for strings.

In this case, apostrophes must be entered as 2 apostrophes - i.e., instead of 'Mike's Pizza' it must be 'Mike''s Pizza'

However, if Quoted Identifiers is off, then "Mike's Pizza" - i.e., single apostrophe - should work.

I don't have a SQL connection to test with here, and I can't remember if turning quoted identifiers off would make strings be passed with double quotes, but it's worth a try.