[Gambas-user] DB.Quote() doesn't quotes apostrophes

[M. Cs.]

I have a dinamically created query text. I don't know the number of
parameters passed to the DB.Exec, so I cannot use &1,&2,... form. I
need to use the DB.Quote()
My problem is: If I have a string
mystring="Blackmore's Night",
the DB.Quote(mystring) won't quote the ', so the query will crash. In
fact I'm getting query string
SELECT * FROM CATALOGS WHERE VName='Blackmore's Night'....
It occurs with sqlite database.
Is there any solution for that?

Thanks!

Csaba