[Gambas-user] Insert thext with " ' " in sqlite database

[Paolo Fagni]

On Jan 23, 2008 2:58 PM, Benoit Minisini <gambas at ...1...>
wrote:

> On mercredi 23 janvier 2008, Paolo Fagni wrote:
> > Hello,
> >
> > I have to insert data in a sqlite database that has this particular form
> :
> >
> > dell'orto
> >
> > I tried to use DB.Quote(string) but the result is
> >
> > 'dell'orto'
> >
> > When I would like to obtain :
> >
> > 'dell''orto'
> >
> > Do I have to change it manually with Replace$() ? Thank you for you
> help.
>
> DB.Quote() should do the job. Which version of Gambas do you use? Which
> database do you access?
>
> I should make a keyboard shortcut for these questions...
>
> Regards,
>
> --
> Benoit Minisini
>
> -------------------------------------------------------------------------
> This SF.net email is sponsored by: Microsoft
> Defy all challenges. Microsoft(R) Visual Studio 2008.
> http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>

As I specified in my first message is a sqlite database, and I'm using
stable 2.0.0 version from arch linux repositories.

IF txtEditorName.Text <> "" THEN
    x = RTrim$(txtEditorName.Text)
    y = RTrim$(txtEditorWeb.Text)
    Message.Info(MDb.getConnection().Quote(x))
...

This is the real code.

Thank you :)

-- 
Paolo Fagni