How to perform an UPDATE SQL command

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

Article #4417

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

#4417

From: Luca
Date: Fri, 21 Dec 2001 18:21

10 lines
1371 bytes

I want to know the right way to perform an update sql command with an
ADOQuery.
In my project I have 3 component: 1 ADOConnection, 1 ADOQuery and 1
DataSource connected to an Access 2000 database. In this way I can
Insert new record, but when I tray to perform an update on an existing
record the compiler return me an error that the dataset is not in edit
or insert mode?


Thanks in advance.

Technical Details

Message-ID: <m5v62u0lvab5i4k9f7ecbhm8204dq00uqd@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!128.230.129.106!news.maxwell.syr.edu!nntp.infostrada.it!news.infostrada.it!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f1add9ae019549b4,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-12-21 10:17:30 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!news.tele.dk!small.news.tele.dk!128.230.129.106!news.maxwell.syr.edu!nntp.infostrada.it!news.infostrada.it!not-for-mail
From: Luca <luca_82@libero.it>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: How to perform an UPDATE SQL command
Message-ID: <m5v62u0lvab5i4k9f7ecbhm8204dq00uqd@4ax.com>
X-Newsreader: Forte Agent 1.8/32.553
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Lines: 10
Date: Fri, 21 Dec 2001 18:21:43 GMT
NNTP-Posting-Host: 151.17.118.36
X-Complaints-To: abuse@iunet.it
X-Trace: news.infostrada.it 1008958903 151.17.118.36 (Fri, 21 Dec 2001 19:21:43 MET)
NNTP-Posting-Date: Fri, 21 Dec 2001 19:21:43 MET
Organization: [Infostrada]