>How is everybody dealing with SQL Passthrough when passing large areas of text
>(memos) typically back to the server? In particular, I see problems with
>embedded string delimiters (') and potentially CHR(0)'s and other control
>characters when sending back binary data.
>
>If I were to send a string like this: "It's a nice day"
>
>and then use: "INSERT SomeTable(SomeMemo) VALUES('"+lcText+"')"
>
>where lcText contains the string above it'll blow up on account of the
>embedded quote.
>
>What am I missing?
>
>+++ Rick ---
cString=chrtran(lcText,chr(34),chr(39))
=sqlExec('INSERT SomeTable(SomeMemo) VALUES("'+cString+'")'
Edward Pikman
Independent Consultant