[Gambas-user] MySQL query problems with apostropies

[Keith Clark]

On Wed, 2010-04-07 at 14:40 -0500, nando wrote:
> Replace will work for quote and backslash
> For double quote:
> 
> doublequote$ is chr$(34)
> Replace$(mystring, chr$(34), "\" & chr$(34)
> 
> But, Benoit had an email of the nice solution.
> -Fernando
> 
> 
Ok, I've tried this:

      DescriptionTextArea.Text = Replace$(DescriptionTextArea.Text, "'",
"\'")
      DescriptionTextArea.Text = Replace$(DescriptionTextArea.Text, Chr
$(34), Chr$(92) & Chr$(34))

But DescriptionTextArea.Text remains unchanged afterwards.