IRowsetUpdate::Update and DBROWSTATU_E_FAIL
"LABELLE, Maxime" <[email protected]> Tue, 20 May 2003 16:13:34 +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_01C31EDA.057D60B4
Content-Type: text/plain;
charset="iso-8859-1"
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.
------_=_NextPart_001_01C31EDA.057D60B4
Content-Type: text/html;
charset="iso-8859-1"
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Generator" CONTENT="MS Exchange Server version 5.5.2650.12">
<TITLE>IRowsetUpdate::Update and DBROWSTATU_E_FAIL</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=2 FACE="Arial">Hi all,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">I'm completely at a loss here, trying to insert a row in a Rowset over a table in</FONT>
<BR><FONT SIZE=2 FACE="Arial">an Oracle database. I have browsed the archives to no avail, and would like</FONT>
<BR><FONT SIZE=2 FACE="Arial">clarifications over what is explained in MSDN regarding this combination of errors.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Basically, the insertion succeeds but transmitting changes to the database</FONT>
<BR><FONT SIZE=2 FACE="Arial">produces an error. The following SQL statement is issued like this:</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">SQL statement: "SELECT A, B FROM MYTABLE WHERE A = 1"</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">DBPROP_IRowsetChange = VARIANT_TRUE</FONT>
<BR><FONT SIZE=2 FACE="Arial">DBPROP_IRowsetUpdate = VARIANT_TRUE</FONT>
<BR><FONT SIZE=2 FACE="Arial">DBPROP_UPDATABILITY = DBPROPVAL_UP_CHANGE | DBPROPVAL_UP_INSERT | DBPROPVAL_UP_DELETE</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">on the column accessor : value of A = 1, value of B = 2</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">IRowsetChange::InsertRow() succeeds,</FONT>
<BR><FONT SIZE=2 FACE="Arial">IRowsetUpdate::Update() fails with a row status DBROWSTATUS_E_FAIL.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Can someone help me clarify what I'm doing wrong ?</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Cheers.</FONT>
<BR><FONT SIZE=2 FACE="Arial">Maxime.</FONT>
</P>
</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_01C31EDA.057D60B4--