Am Samstag, den 10.08.2013, 00:02 -0700 schrieb bill-lancaster:
> Have seen a couple of posts that refer to this but can't quite understand the
> answer
>
> I have a database which conntains a string 'Queen's Head'
>
> so
> hResult = hConn.Exec("SELECT contacts.* FROM contacts WHERE Title =
> 'Queen's Head'")
> produces an error.
>
> How best to solve this?
>
Salut,
and this work also:
hResult = hConn.Exec("SELECT contacts.* FROM contacts WHERE Title
=&1" ,"'Queen's Head'") ' that is the gambas way
or
hResult = hConn.Exec("SELECT contacts.* FROM contacts WHERE Title =" &
Replace("'Queen's Head'","'","''")) ' that is the SQL way
** both examples not tested
--
Amicalement
Charlie
------------------------------------------------------------------------------
Get 100% visibility into Java/.NET code with AppDynamics Lite!
It's a free troubleshooting tool designed for production.
Get down to code-level detail for bottlenecks, with <2% overhead.
Download for free and get started troubleshooting in minutes.
http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk
_______________________________________________
Gambas-user mailing list
Gambas-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/gambas-user
