Hi everyone. This is carried over from the thread I should not have started at <u...@lists.gambas-basic.org>, for which I apologise.
Many thanks for the suggestions put forward. I think I need to clarify a little. 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 . What I mean by a syntax error is that the Basic IDE underlines in red everything from the first double quote and any attempt to run the code throws "Syntax error in MODmain module at line 26". I also tried with this line: $Query = “SELECT * FROM abpa.tblParameters" which bypasses any string conversions as above. I have tried inserting a semicolon at the end of the statement within the double quotes. I have tried putting the table name within single quotes. I have run out of ideas. So the question really is: is there an error in the code posted on the Wiki, or is it my use of the code which is in error? Right now, following the code example, I still cannot connect to my database. Kind regards, Doug ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, Slashdot.org! http://sdm.link/slashdot _______________________________________________ Gambas-user mailing list Gambas-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/gambas-user
