Article View: borland.public.cppbuilder.database.ado
Article #18Re: Desperate help needed - INSERT issues.
From: Clayton Arends
Date: Sat, 22 Mar 2008 03:08
Date: Sat, 22 Mar 2008 03:08
16 lines
1501 bytes
1501 bytes
"Mike Collins" <its@TheBottomOfThePost> wrote in message
news:47e46771$1@newsgroups.borland.com...
> INSERT INTO StaffSEN
> (staffId, senId, description, action)
> VALUES ("12345a", 3, "some description", "some action");
"action" might be a Jet reserved word. Try putting square brackets around
it:
INSERT INTO StaffSEN
(staffId, senId, description, [action])
...
HTH,
Clayton
Technical Details
Message-ID:
<47e47840$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.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: "Clayton Arends" <nospam_claytonarends@hotmail.com> Newsgroups: borland.public.cppbuilder.database.ado References: <47e46771$1@newsgroups.borland.com> In-Reply-To: <47e46771$1@newsgroups.borland.com> Subject: Re: Desperate help needed - INSERT issues. Date: Fri, 21 Mar 2008 20:08:49 -0700 Lines: 17 MIME-Version: 1.0 Content-Type: text/plain; format=flowed; charset="Windows-1252"; reply-type=response Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Windows Mail 6.0.6000.16480 X-MimeOLE: Produced By Microsoft MimeOLE V6.0.6000.16545 NNTP-Posting-Host: 68.185.45.89 Message-ID: <47e47840$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1206155328 68.185.45.89 (21 Mar 2008 20:08:48 -0700) Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!news.isoc.lu!newsgroups.borland.com!not-for-mail