>>Use the square brackets [ ] to avoid this situation...
>
>That solves the VFP end of things but not the SQL end of it...
>
>Even if it didn't you still have the possibility of an embedded ] in binary data.
>I don't see a way to send binary data which could contain *any* kind of delimiter
>combination you may throw at it.
>
>+++ Rick ---
Big overhead, but you can check if the delemiter is in the string before the sending and use the apropriate delimiter.
Also if all delimiters are include in the string, try breaking it in smaller parts with the right delimiters and send it with '+' between each part.
Yes, big overhead...
: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