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

Benoit Minisini gambas at ...1...
Wed Jan 23 14:58:22 CET 2008


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




More information about the User mailing list