[Gambas-user] What is wrong with my query syntax?

[Johny Provoost]

I always use

$Query = “SELECT * FROM Friends WHERE Name = ” & "\"" & TBXName.Text & "\""

and use formname.TBXNamer.Text but don't know if that's the problem

By the way, This maillist is changed to 
'gambas-user at lists.sourceforge.net'.  You should use this one.

Kind Regards,

Johny


Op 29-12-17 om 04:43 schreef Doug Hutcheson:
> Hi. I'm a new user and I have misunderstood something.
>
> I am trying to establish a connection to a PostgreSQL database.
>
>  At http://gambaswiki.org/wiki/howto/database?ht=database-manager, 
> point 6, I read the following example of a query:
>                 Dim $Query As String
>                $Query = “SELECT * FROM Friends WHERE Name = '” & 
> TBXName.Text & “'”
>
> However, no matter how I try, I always get a syntax error on the 
> assignment line. Obviously I am missing something - can you help?
>
> Kind regards,
> Doug
>
>
> --------------------------------------------------
>
> This is the Gambas Mailing List
> https://lists.gambas-basic.org/listinfo/user
>
> Hosted by https://www.hostsharing.net