Article View: borland.public.cppbuilder.database.multi-tier
Article #43Strange Semi-Colon in SQL
From: Curt
Date: Tue, 02 Mar 2004 07:18
Date: Tue, 02 Mar 2004 07:18
21 lines
1573 bytes
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 ?
Technical Details
Message-ID:
<40443491$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,aff855f438a25a33,start X-Google-Attributes: gidfcd2b,public X-Google-ArrivalTime: 2004-03-01 23:39:42 PST From: "Curt" <a@aol.com> Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Strange Semi-Colon in SQL Date: Mon, 1 Mar 2004 23:18:30 -0800 Lines: 24 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 NNTP-Posting-Host: 208.13.134.8 Message-ID: <40443491$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1078211729 208.13.134.8 (1 Mar 2004 23:15:29 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail