Hi everyone.
I have solved it. The problem was that cutting and pasting from the
wiki brought across some unwanted non-printing character(s). When I
typed the assignment line in by hand, there was no syntax error. Many
thanks who replied on the other thread, as I have learned something in
the process.
Kind regards,
Doug
On Sat, 2017-12-30 at 15:43 +1000, Doug Hutcheson wrote:
> Hi everyone. This is carried over from the thread I should not have
> started at <us...@li...>, 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
>
|
