Oracle OLE C++ Classes/SELECT works/ INSERT fails

From: steven <rgc_at_newsguy.com>
Date: Sat, 11 Aug 2001 22:52:57 -0700
Message-ID: <0c6cntko0b2numde3ae99s6b2lp1pbi2l2_at_4ax.com>

The select statement below works great, but when I try to insert, the (ores != OSUCCESS). Can read from
TB1 but can not write.

Please Help

//****************************************************

OSession  oses;  // database session object
ODatabase odb;   // the database object
ODynaset  oDB1;  // dynaset object
oresult   ores;  // indicates whether operation succeeded
OStartup();     // Start Environment


//     open the default (unnamed) session

if(!oses.IsOpen())
 ores = oses.Open();
if (ores != OSUCCESS)
 MessageBox("oses.Open:", oses.GetErrorText() , MB_OK);

// connect to the database

if(!odb.IsOpen())
 ores = odb.Open(oses, "MyDB.world", "system", "manager"); if (ores != OSUCCESS)
 MessageBox("ores.Open:", oses.GetErrorText() , MB_OK);

//******************************************************

strcpy(strFilter, "SELECT * FROM TBL1 WHERE FLD1 = 'A001'"); if(oDB1.IsOpen())
 oDB1.Close();
ores = oDB1.Open(odb, strFilter);
if (ores != OSUCCESS)
 MessageBox("oDB1.Open-Error:", oses.GetErrorText() , MB_OK);

//******************************************************

strcpy(strFilter, "INSERT INTO TBL1 VALUES ('A002')"); if(oDB1.IsOpen())
 oDB1.Close();
ores = oDB1.Open(odb, strFilter);
if (ores != OSUCCESS)
 MessageBox("oDB1.Open-Error:", oses.GetErrorText() , MB_OK); Received on Sun Aug 12 2001 - 07:52:57 CEST