ExecuteNonQuery() returns 0

ExecuteNonQuery() returns 0

Postby sprinter252 » Wed 05 Dec 2007 15:31

Hello,

I'm using Corelab.Oracle in Version 4.30.25.0. Now, if I execute a C#-code like this
Code: Select all
// get a factory for database-access
IDatabase dbsThis = Tools.GetDefaultDatabase();
IDbCommand cmdThis = dbsThis.GetCommandObject();           
cmdThis.CommandText = @"INSERT INTO TBL_CASE_MEMOS (FK_CASE, MEMO_TEXT, FK_EDITOR) VALUES (:1, :2, :3)";
cmdThis.Parameters.Add(dbsThis.GenerateParameter("1", DbType.Int32, 8545, ParameterDirection.Input));
cmdThis.Parameters.Add(dbsThis.GenerateParameter("2", DbType.String, "Test", ParameterDirection.Input));
cmdThis.Parameters.Add(dbsThis.GenerateParameter("3", DbType.Int32, 1851, ParameterDirection.Input));
MessageBox.Show(cmdThis.ExecuteNonQuery().ToString());

I'll get a messagebox with the value "1" -> thats what I expect!!! :D

But if I call the same code inside a transaction I get 0 as the return value of ExecuteNonQuery(). Is there any known issue about this behaviour?

Thx, Alex[/code]
sprinter252
 
Posts: 23
Joined: Fri 16 Nov 2007 20:10
Location: Germany

Postby Paul » Thu 06 Dec 2007 13:43

We cannot reproduce this problem. Please send us complete sample to demonstrate it and include script
to create server objects.
Paul
 
Posts: 725
Joined: Thu 28 Oct 2004 14:06


Return to dotConnect for Oracle