Article View: borland.public.cppbuilder.database.ado
Article #204adoquery error
From: bill
Date: Fri, 15 Jun 2007 19:04
Date: Fri, 15 Jun 2007 19:04
14 lines
1517 bytes
1517 bytes
i have a very strange problem when executing a sql query from an adoquery
i want to execute:
"Insert into table1 values ('abc','def','ghj')"
this sql statement is executed perfectly when i run it from the database
(sql server). if i put it in the
adoquery properties sql it is executed successfully too. but if i do:
DataModule1->ADOQuery1->SQL->CommaText="Insert into table1 values
('abc','def','ghj')";
DataModule1->ADOQuery1->ExecSQL();
i get an error "syntax error near def". from many tests i came to realize
that the problem is the comma after the 'abc'.
how can i solve this issue?
thank you
Technical Details
Message-ID:
<4672e2bd@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Thread: 10698b,5e327e5b8c33feb6,start X-Google-Attributes: gid10698b,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "bill" <billaras1234@hotmail.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: adoquery error Date: Fri, 15 Jun 2007 20:04:28 +0100 Lines: 16 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.2180 X-RFC2646: Format=Flowed; Original X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 NNTP-Posting-Host: 131.227.231.162 Message-ID: <4672e2bd@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1181934269 131.227.231.162 (15 Jun 2007 12:04:29 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news2.google.com!news.glorb.com!newsgate.cistron.nl!xs4all!feeder.news-service.com!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail