Article View: borland.public.cppbuilder.database.ado
Article #1543Strange OLE-DB error
From: Palmetzhofer Dietmar
Date: Wed, 12 May 2004 21:18
Date: Wed, 12 May 2004 21:18
85 lines
2882 bytes
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-mailShow 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