>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 ---
Use the square brackets [ ] to avoid this situation...
:0)
If we exchange an apple, we both get an apple.
But if we exchange an idea, we both get 2 ideas, cool...Gérald Santerre
Independant programmer - internet or intranet stuff - always looking for contracts big or small :)
http://www.siteintranet.qc.ca