[Gambas-user] Problems with ampersand in a string

[Benoit Minisini]

On Wednesday 11 May 2005 09:33, Rolf Schmidt wrote:
> Hi everybody out there
>
> I try to query a postgersql database where the string contains an ampersand
> char which results in an error.
>
> So I try to substitute the "&" with a "%" char and use the "like"-operator,
> but I didn't see any modification after the substitute command:
>
>      tmp = Replace$(string1, "&", "%")
>
> even with charset conversion
>
>    tmp = Replace$(string1, Conv$("&", System.Charset, "UTF-8"), "%")
>
> I also tried the "qoute"-Operator, which doesn't help either.
>
> What are my mistakes?
> In use is Gambas 1.9.3 - because I'm waiting for new Debian packages at
> linex (does anybody knows, when they are available?).
>
> Many thanks for help
> Rolf

The query string in all Gambas database methods (Find, Edit, Exec) work like 
the Subst$() function. Look at the documentation! ;-)

Regards,

-- 
Benoit Minisini
mailto:gambas at ...1...