Re: IRowsetUpdate::Update and DBROWSTATU_E_FAIL
Alan Gamboa <[email protected]> Wed, 21 May 2003 03:21:00 -0400
| Newsgroups | gmane.comp.windows.devel.oledb.devel |
|---|---|
| Message-ID | <[email protected]> |
This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C31F69.87A301E0 Content-Type: text/plain Are you using some form of OpenWithServiceComponents() from CDataSource ? -----Original Message----- From: Kjell Arild Tangen [mailto:[email protected]] Sent: Wednesday, May 21, 2003 1:40 AM To: [email protected] Subject: Re: [OLEDB_DEV] IRowsetUpdate::Update and DBROWSTATU_E_FAIL This is a provider-specific error. Which provider are you using? The provider often provides some sensible error information. What does it say? Kjell -----Original Message----- From: LABELLE, Maxime [mailto:[email protected]] Sent: 20. mai 2003 16:14 To: [email protected] Subject: [OLEDB_DEV] IRowsetUpdate::Update and DBROWSTATU_E_FAIL Hi all, I'm completely at a loss here, trying to insert a row in a Rowset over a table in an Oracle database. I have browsed the archives to no avail, and would like clarifications over what is explained in MSDN regarding this combination of errors. Basically, the insertion succeeds but transmitting changes to the database produces an error. The following SQL statement is issued like this: SQL statement: "SELECT A, B FROM MYTABLE WHERE A = 1" DBPROP_IRowsetChange = VARIANT_TRUE DBPROP_IRowsetUpdate = VARIANT_TRUE DBPROP_UPDATABILITY = DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE on the column accessor : value of A = 1, value of B = 2 IRowsetChange::InsertRow() succeeds, IRowsetUpdate::Update() fails with a row status DBROWSTATUS_E_FAIL. Can someone help me clarify what I'm doing wrong ? Cheers. Maxime. You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or subscribe to other DevelopMentor lists at http://discuss.develop.com. You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or subscribe to other DevelopMentor lists at http://discuss.develop.com. ------_=_NextPart_001_01C31F69.87A301E0 Content-Type: text/html Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <html xmlns:o=3D"urn:schemas-microsoft-com:office:office" = xmlns:w=3D"urn:schemas-microsoft-com:office:word" = xmlns=3D"http://www.w3.org/TR/REC-html40"> <head> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Dus-ascii"> <meta name=3DProgId content=3DWord.Document> <meta name=3DGenerator content=3D"Microsoft Word 10"> <meta name=3DOriginator content=3D"Microsoft Word 10"> <link rel=3DFile-List href=3D"cid:[email protected]"> <title>Message</title> <!--[if gte mso 9]><xml> <o:OfficeDocumentSettings> <o:DoNotRelyOnCSS/> </o:OfficeDocumentSettings> </xml><![endif]--><!--[if gte mso 9]><xml> <w:WordDocument> <w:SpellingState>Clean</w:SpellingState> <w:GrammarState>Clean</w:GrammarState> <w:DocumentKind>DocumentEmail</w:DocumentKind> <w:EnvelopeVis/> <w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel> </w:WordDocument> </xml><![endif]--> <style> <!-- /* Font Definitions */ @font-face {font-family:Tahoma; panose-1:2 11 6 4 3 5 4 4 2 4; mso-font-charset:0; mso-generic-font-family:swiss; mso-font-pitch:variable; mso-font-signature:1627421319 -2147483648 8 0 66047 0;} /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {mso-style-parent:""; margin:0in; margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue; text-decoration:underline; text-underline:single;} a:visited, span.MsoHyperlinkFollowed {color:purple; text-decoration:underline; text-underline:single;} p {mso-margin-top-alt:auto; margin-right:0in; mso-margin-bottom-alt:auto; margin-left:0in; mso-pagination:widow-orphan; font-size:12.0pt; font-family:"Times New Roman"; mso-fareast-font-family:"Times New Roman";} span.EmailStyle18 {mso-style-type:personal-reply; mso-style-noshow:yes; mso-ansi-font-size:10.0pt; mso-bidi-font-size:10.0pt; font-family:Arial; mso-ascii-font-family:Arial; mso-hansi-font-family:Arial; mso-bidi-font-family:Arial; color:navy;} span.SpellE {mso-style-name:""; mso-spl-e:yes;} span.GramE {mso-style-name:""; mso-gram-e:yes;} @page Section1 {size:8.5in 11.0in; margin:1.0in 1.25in 1.0in 1.25in; mso-header-margin:.5in; mso-footer-margin:.5in; mso-paper-source:0;} div.Section1 {page:Section1;} --> </style> <!--[if gte mso 10]> <style> /* Style Definitions */=20 table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0in 5.4pt 0in 5.4pt; mso-para-margin:0in; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan; font-size:10.0pt; font-family:"Times New Roman";} </style> <![endif]--> </head> <body lang=3DEN-US link=3Dblue vlink=3Dpurple = style=3D'tab-interval:.5in'> <div class=3DSection1> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'>Are you using some form of <span class=3DSpellE><span = class=3DGramE>OpenWithServiceComponents</span></span><span class=3DGramE>(</span>) from <span class=3DSpellE>CDataSource</span> = ?<o:p></o:p></span></font></p> <p class=3DMsoNormal><font size=3D2 color=3Dnavy face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial;color:navy'><o:p> </o:p></span></font></p>= <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = face=3DTahoma><span style=3D'font-size:10.0pt;font-family:Tahoma'>-----Original = Message-----<br> <b><span style=3D'font-weight:bold'>From:</span></b> Kjell Arild Tangen [mailto:[email protected]] <br> <b><span style=3D'font-weight:bold'>Sent:</span></b> Wednesday, May 21, = 2003 1:40 AM<br> <b><span style=3D'font-weight:bold'>To:</span></b> = [email protected]<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> Re: [OLEDB_DEV] IRowsetUpdate::Update and DBROWSTATU_E_FAIL</span></font></p> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'><o:p> </o:p></span></font></p> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = color=3Dblue face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:blue'>This is a provider-specific error. Which provider are you using? The provider = often provides some sensible error information. What does it = say?</span></font><o:p></o:p></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'> <o:p></o:p></span></font></p> </div> <div> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D2 = color=3Dblue face=3DArial><span style=3D'font-size:10.0pt;font-family:Arial;color:blue'>Kjell</span></fo= nt><o:p></o:p></p> </div> <blockquote style=3D'margin-top:5.0pt;margin-bottom:5.0pt' DEFANGED_style=3D"PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: = #0000ff 2px solid; MARGIN-RIGHT: 0px"> <p class=3DMsoNormal = style=3D'mso-margin-top-alt:0in;margin-right:0in;margin-bottom: 12.0pt;margin-left:.5in'><font size=3D2 face=3DTahoma><span = style=3D'font-size:10.0pt; font-family:Tahoma'>-----Original Message-----<br> <b><span style=3D'font-weight:bold'>From:</span></b> LABELLE, Maxime [mailto:[email protected]] <br> <b><span style=3D'font-weight:bold'>Sent:</span></b> 20. mai 2003 = 16:14<br> <b><span style=3D'font-weight:bold'>To:</span></b> = [email protected]<br> <b><span style=3D'font-weight:bold'>Subject:</span></b> [OLEDB_DEV] IRowsetUpdate::Update and = DBROWSTATU_E_FAIL</span></font><o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>Hi all,</span></font> <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>I'm completely at a loss here, trying to = insert a row in a Rowset over a table in</span></font> <br> <font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'>an Oracle database. I have browsed the archives to no avail, and would = like</span></font> <br> <font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'>clarifications over what is explained in MSDN regarding this combination of = errors.</span></font> <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>Basically, the insertion succeeds but = transmitting changes to the database</span></font> <br> <font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'>produces an error. The following SQL statement is issued like = this:</span></font> <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>SQL statement: "SELECT A, B FROM MYTABLE = WHERE A =3D 1"</span></font> <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>DBPROP_IRowsetChange =3D = VARIANT_TRUE</span></font> <br> <font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'>DBPROP_IRowsetUpdate =3D VARIANT_TRUE</span></font> <br> <font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'>DBPROP_UPDATABILITY =3D DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | = DBPROPVAL_UP_DELETE</span></font> <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>on the column accessor : value of A =3D 1, = value of B =3D 2</span></font> <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>IRowsetChange::InsertRow() = succeeds,</span></font> <br> <font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'>IRowsetUpdate::Update() fails with a row status DBROWSTATUS_E_FAIL.</span></font> = <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>Can someone help me clarify what I'm doing = wrong ?</span></font> <o:p></o:p></p> <p style=3D'margin-left:.5in'><font size=3D2 face=3DArial><span = style=3D'font-size: 10.0pt;font-family:Arial'>Cheers.</span></font> <br> <font size=3D2 face=3DArial><span = style=3D'font-size:10.0pt;font-family:Arial'>Maxime.</span></font> <o:p></o:p></p> <p class=3DMsoNormal style=3D'margin-left:.5in'><font size=3D3 = face=3D"Times New Roman"><span style=3D'font-size:12.0pt'>You can read messages from the OLEDB_DEV = archive, unsubscribe from OLEDB_DEV, or subscribe to other DevelopMentor lists = at http://discuss.develop.com.<o:p></o:p></span></font></p> </blockquote> </div> </body> </html> You can read messages from the OLEDB_DEV archive, unsubscribe from = OLEDB_DEV, or subscribe to other DevelopMentor lists at = http://discuss.develop.com. You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or subscribe to other DevelopMentor lists at http://discuss.develop.com. ------_=_NextPart_001_01C31F69.87A301E0--