🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Strange OLE-DB error

#1543
From: Palmetzhofer Dietmar
Date: Wed, 12 May 2004 21:18
85 lines
2882 bytes
I am making an update-Operation in an TADOQuery using Parameters.
The first time I am executing the statement, everything works fine.
But when I am trying to do the same thing a second time, I�ll get the
following
error:
"Error in an OLE-DB operation, consisting of of more than one step"
(the message is in german, so the translation might not be correct;
the german message is:
"Fehler bei einer aus meheren Schritten bestehenden OLE-DB Operation")
I am using BCB 6.0 against a MSAccess 2000 database.

Here is the statement:
UPDATE CONES_AuswSystemleistung

SET

Ausw_ZeitbedarfMontage= :DauerMobilkranSum,

Ausw_ProduktivitaetFaellung= :Prodf,

Ausw_ProduktivitaetRueckung= :Prodr,

Ausw_EntnahmeVolumen= :Nutzunglfm,

Ausw_ZeitmdP0= :DauerMobilkranP0,

Ausw_ZeitmdP1= :DauerMobilkranP1,

Ausw_ZeitmdP2= :DauerMobilkranP2,

Ausw_ZeitmdP3= :DauerMobilkranP3,

Ausw_ZeitmdP4= :DauerMobilkranP4,

Ausw_ZeitmdP5= :DauerMobilkranP5,

Ausw_ZeitmdP6= :DauerMobilkranP6,

Ausw_ProdfP0= :ProdfP0,

Ausw_ProdfP1= :ProdfP1,

Ausw_ProdfP2= :ProdfP2,

Ausw_ProdfP3= :ProdfP3,

Ausw_ProdfP4= :ProdfP4,

Ausw_ProdfP5= :ProdfP5,

Ausw_ProdfP6= :ProdfP6,

Ausw_ProdrP0= :ProdrP0,

Ausw_ProdrP1= :ProdrP1,

Ausw_ProdrP2= :ProdrP2,

Ausw_ProdrP3= :ProdrP3,

Ausw_ProdrP4= :ProdrP4,

Ausw_ProdrP5= :ProdrP5,

Ausw_ProdrP6= :ProdrP6,

Ausw_NutzVlfmP0= :NutzunglfmP0,

Ausw_NutzVlfmP1= :NutzunglfmP1,

Ausw_NutzVlfmP2= :NutzunglfmP2,

Ausw_NutzVlfmP3= :NutzunglfmP3,

Ausw_NutzVlfmP4= :NutzunglfmP4,

Ausw_NutzVlfmP5= :NutzunglfmP5,

Ausw_NutzVlfmP6= :NutzunglfmP6

WHERE

Ausw_Szenarionr= :Szenarionr;

Hope, someone can help!
Technical Details
Message-ID: <40a2943c@newsgroups.borland.com>
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-05!sn-xit-11!sn-xit-09!supernews.com!sjc1.usenetserver.com!news.usenetserver.com!border1.nntp.sjc.giganews.com!border2.nntp.sjc.giganews.com!nntp.giganews.com!cyclone-sf.pbi.net!216.218.192.242!news.he.net!news-hog.berkeley.edu!ucberkeley!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: GERMAN,ASCII
X-Google-Thread: 10698b,2bb8ad5b7269d7e9,start
X-Google-Attributes: gid10698b,public
Reply-To: "Palmetzhofer Dietmar" <xxremovethisxx_dietmar.palmetzhofer@boku.ac.at>
From: "Palmetzhofer Dietmar" <xxremovethisxx_dietmar.palmetzhofer@boku.ac.at>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Strange OLE-DB error
Date: Wed, 12 May 2004 23:18:58 +0200
Lines: 88
Organization: Univ. f. Bodenkultur
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 193.170.68.244
Message-ID: <40a2943c@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1084396604 193.170.68.244 (12 May 2004 14:16:44 -0700)
Path: arc1-ca.pugleaf.net!controlnews3.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-05!sn-xit-11!sn-xit-09!supernews.com!sjc1.usenetserver.com!news.usenetserver.com!border1.nntp.sjc.giganews.com!border2.nntp.sjc.giganews.com!nntp.giganews.com!cyclone-sf.pbi.net!216.218.192.242!news.he.net!news-hog.berkeley.edu!ucberkeley!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail