Re: IRowsetUpdate::Update and DBROWSTATU_E_FAIL
Kjell Arild Tangen <[email protected]> Wed, 21 May 2003 07:39:50 +0200
| 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_01C31F5B.65FA18C0 Content-Type: text/plain 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. ------_=_NextPart_001_01C31F5B.65FA18C0 Content-Type: text/html <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii"> <TITLE>Message</TITLE> <META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD> <BODY> <DIV><SPAN class=208133305-21052003><FONT face=Arial color=#0000ff size=2>This is a provider-specific error. Which provider are you using? The provider often provides some sensible error information. What does it say?</FONT></SPAN></DIV> <DIV><SPAN class=208133305-21052003><FONT face=Arial color=#0000ff size=2></FONT></SPAN> </DIV> <DIV><SPAN class=208133305-21052003><FONT face=Arial color=#0000ff size=2>Kjell</FONT></SPAN></DIV> <BLOCKQUOTE DEFANGED_style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px"> <DIV></DIV> <DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma size=2>-----Original Message-----<BR><B>From:</B> LABELLE, Maxime [mailto:[email protected]] <BR><B>Sent:</B> 20. mai 2003 16:14<BR><B>To:</B> [email protected]<BR><B>Subject:</B> [OLEDB_DEV] IRowsetUpdate::Update and DBROWSTATU_E_FAIL<BR><BR></FONT></DIV> <P><FONT face=Arial size=2>Hi all,</FONT> </P> <P><FONT face=Arial size=2>I'm completely at a loss here, trying to insert a row in a Rowset over a table in</FONT> <BR><FONT face=Arial size=2>an Oracle database. I have browsed the archives to no avail, and would like</FONT> <BR><FONT face=Arial size=2>clarifications over what is explained in MSDN regarding this combination of errors.</FONT> </P> <P><FONT face=Arial size=2>Basically, the insertion succeeds but transmitting changes to the database</FONT> <BR><FONT face=Arial size=2>produces an error. The following SQL statement is issued like this:</FONT> </P> <P><FONT face=Arial size=2>SQL statement: "SELECT A, B FROM MYTABLE WHERE A = 1"</FONT> </P> <P><FONT face=Arial size=2>DBPROP_IRowsetChange = VARIANT_TRUE</FONT> <BR><FONT face=Arial size=2>DBPROP_IRowsetUpdate = VARIANT_TRUE</FONT> <BR><FONT face=Arial size=2>DBPROP_UPDATABILITY = DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE</FONT> </P> <P><FONT face=Arial size=2>on the column accessor : value of A = 1, value of B = 2</FONT> </P> <P><FONT face=Arial size=2>IRowsetChange::InsertRow() succeeds,</FONT> <BR><FONT face=Arial size=2>IRowsetUpdate::Update() fails with a row status DBROWSTATUS_E_FAIL.</FONT> </P> <P><FONT face=Arial size=2>Can someone help me clarify what I'm doing wrong ?</FONT> </P> <P><FONT face=Arial size=2>Cheers.</FONT> <BR><FONT face=Arial size=2>Maxime.</FONT> </P>You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV, or subscribe to other DevelopMentor lists at http://discuss.develop.com.</BLOCKQUOTE></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. ------_=_NextPart_001_01C31F5B.65FA18C0--