Re: BCB6 - Access2000 - Syntax error in Update statement - Article 2187 - go-pugleaf

Article View: borland.public.cppbuilder.database.ado

Article #2187

Back to borland.public.cppbuilder.database.ado Previous Next

Re: BCB6 - Access2000 - Syntax error in Update statement

#2187

From: Matt Jacobs
Date: Thu, 02 Oct 2003 16:27

19 lines
1757 bytes

"Claude" <claude@dev.scomage.com> wrote:

>I am getting a Class EOleError when updating a row to an MS Access table.
>Seconds ago I inserted the row.
>I only get this error when I update a character column. (it happens to be
>the last column of the table.)
>I can update other character columns and numeric columns of the row.

How many columns are in the table?

I believe there are still issues with optimistic locking and Access,
in that an error occurs if there are too many columns listed in the
where clause. In the BDE days, we got around that by changing the
dataset UpdateMode property.

TBetterADODataSet has a property called Update_Criteria that serves
the same purpose as BDE's UpdateMode. You may want to look at that.

Or you may have an entirely different problem. ;-)

Technical Details

Message-ID: <5ujonv89r83t8jtvvm57j1kdtt3grdh8qm@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

References: <3f79f373$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,3a5aa46fea01f476
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-10-02 10:44:12 PST
From: Matt Jacobs <noyb@noyb.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: BCB6 - Access2000 - Syntax error in Update statement
Date: Thu, 02 Oct 2003 09:27:12 -0700
Reply-To: __noyb@noyb.com
Message-ID: <5ujonv89r83t8jtvvm57j1kdtt3grdh8qm@4ax.com>
References: <3f79f373$1@newsgroups.borland.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 12.208.33.54
X-Trace: newsgroups.borland.com 1065112213 12.208.33.54 (2 Oct 2003 09:30:13 -0700)
Lines: 19
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-09!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Reply to Parent Message