🚀 go-pugleaf

Wow! just found out that I had been terminating the SQL command text with a
semi-colon.

"Curt" <a@aol.com> wrote in message
news:40443491$1@newsgroups.borland.com...
> I am trying to set up a very simple test application to fetch data from a
> MySQL database and edit the fetched records in a TDBGrid.  I get the
message
> 'You have an error in your SQL syntax.'
>
> I've attached a TSQLMonitor to the connection and it tells me that the
> automatically generated SQL is :
>
> update servers;  set
>  port_num = '110'
> where
>  serverNum = '1' and
>  hostname = 'hostname' and
>  port_num = '120' and
>  account_name = 'name' and
>  account_password = 'pass' and
>  active = '1'
>
> There is a semi-colon after the 'update servers' clause.  I know this is
not
> valid SQL and is probably causing the problem ?  If so, how can I get rid
of
> it considering that the SQL statement is automatically generated by the
> DataSetProvider ?
>
>
>