Strange Semi-Colon in SQL

Thread View: borland.public.cppbuilder.database.multi-tier

2 messages

[T] Back to Threads [V] Tree View [G] Group Articles

2 total messages Started by Curt Tue, 02 Mar 2004 07:18

#43

Author: Curt
Date: Tue, 02 Mar 2004 07:18

21 lines
1573 bytes

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 ?

Re: Strange Semi-Colon in SQL

#44

Author: Curt
Date: Tue, 02 Mar 2004 08:10

32 lines
1859 bytes

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 ?
>
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads