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

[M. Cs.]

I found a way to do, but I didn't understand what Benoit wanted:
If I have a query, I can always do the following:
Replace
"SELECT * FROM  CATALOGS WHERE VName=....."
with
"SELECT * FROM  CATALOGS WHERE " & DB.Subst("VName=&1",...) & "..."

That can solve the problem.
I'm sorry but something can be very obvious for you, and not so clear
to somebody not involved into Gambas! From the documentation I
couldn't tell what is the difference between the quotation used by
DB.Exec() and what's the gain from a function like  DB.Subst().
This is really a painfull point in the documentations.

Thanks anyway!
Csaba

2012/1/23, Caveat <Gambas at ...1950...>:
> Why not just process one term at a time?
>
>
>   Dim conn As Connection
>   Dim termStr As String
>   Dim terms As String[]
>   Dim enteredTerm, escapedTerm As String
>
>   ...
>   conn = DataAccess.getConnection()
>   ...
>   ' Get termStr from the input box
>   'termStr = txtQueryInput.Text
>
>   ' Set termStr manually for testing
>   termStr = "abc def he's fill kill''d fine &1 %2 it's%"
>
>   terms = Split(termStr, " ")
>   For Each enteredTerm In terms
>     escapedTerm = DB.Subst("&1", enteredTerm)
>     ' do something with the escaped term...
>     ...
>   Next
>
> Kind regards,
> Caveat
>
>
> ------------------------------------------------------------------------------
> Try before you buy = See our experts in action!
> The most comprehensive online learning library for Microsoft developers
> is just $99.99! Visual Studio, SharePoint, SQL - plus HTML5, CSS3, MVC3,
> Metro Style Apps, more. Free future releases when you subscribe now!
> http://p.sf.net/sfu/learndevnow-dev2
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
>