You have a point if the update is done through SQL-passthrough. But thru a remote view, this is not an issue.
>You have to watch out for the delimiters. If the memo field is delimited with single quotes, which I think is the default, and you have a single quote somewhere in you memo field string, the update will fail. There is a setting for 'Quoted Identifiers' in the ODBC driver setup and in SQL Server that govern this behavoir. I choose to leave it set the way it was place and additional single quote next to all single quotes before an update. This way I can still use single quotes in my memo strings and the updates won't fail.
>
>Charlie
Dan LeClair
www.cyberwombat.comSET RANT ON - The Wombat BlogLife isn’t a morality contest and purity makes a poor shield. - J. Peter MulhernDisclaimer: The comments made here are only my OPINIONS on various aspects of VFP, SQL Server, VS.NET, systems development, or life in general, and my OPINIONS should not be construed to be the authoritative word on any subject. No warranties or degrees of veracity are expressed or implied. Void where prohibited. Side effects may included dizziness, spontaneous combustion, or unexplainable cravings for dark beer. Wash with like colors only, serve immediately for best flavor.
