Article View: borland.public.cppbuilder.database.ado
Article #19Re: Desperate help needed - INSERT issues.
From: Minas
Date: Sat, 22 Mar 2008 08:22
Date: Sat, 22 Mar 2008 08:22
24 lines
1659 bytes
1659 bytes
"Mike Collins" <its@TheBottomOfThePost> wrote:
> Hi all, first off, happy Easter.
Happy Easter Mike,
> Project SupportMIS.exe raised exception class EOleException with message
> 'Syntax error in INSERT INTO statement'. Process stopped. Use Step or Run
> to continue.
> Now, I need to do an INSERT statement to link a staff member to a SEN
> course. I have the staffId and senId, and so i;m attempting something
> like
> INSERT INTO StaffSEN
> (staffId, senId, description, action)
> VALUES ("12345a", 3, "some description", "some action");
>
> However, when i do this, i get an exception raised.
What the exception says ? Do you use Open() method to execute the query ?
if so , use ExecSQL() method instead, since the query is an INSERT statement
Best Regards
Minas
Technical Details
Message-ID:
<47e4c074@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!feeder.erje.net!news.isoc.lu!newsgroups.borland.com!not-for-mailReferences:
<47e46771$1@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Thread: 10698b,1ca92cff8c459d51 X-Google-Attributes: gid10698b,public,usenet X-Google-Language: ENGLISH,ASCII-7-bit From: "Minas" <no email> Newsgroups: borland.public.cppbuilder.database.ado References: <47e46771$1@newsgroups.borland.com> Subject: Re: Desperate help needed - INSERT issues. Date: Sat, 22 Mar 2008 10:22:14 +0200 Lines: 26 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2900.3138 X-RFC2646: Format=Flowed; Response X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.3198 NNTP-Posting-Host: 62.1.228.50 Message-ID: <47e4c074@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1206173812 62.1.228.50 (22 Mar 2008 01:16:52 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!proxad.net!feeder1-2.proxad.net!feeder.erje.net!news.isoc.lu!newsgroups.borland.com!not-for-mail