|
-
Jul 6th, 2006, 02:40 PM
#1
Thread Starter
Hyperactive Member
[RESOLVED] syntax issue with sql statement..driving me nuts
I am using a inline sql statement to update a table (in oracle).
Some how this statement doesn't run.
sUpdateStatement = "UPDATE AUTOTRADE.RATE_ADVANCES SET TREASURY_RATE = '" + dLiveBM + "'";
OracleConnection _oOracleConnection = new OracleConnection(sConnectionstring);
_oOracleConnection.Open();
OracleCommand _oOracleCommand = new OracleCommand(sUpdateStatement, _oOracleConnection);
_oOracleCommand.CommandText = sUpdateStatement;
try
{
//code hangs here . no output at all. I don't know whats going on.
//the sUpdateStatement has the following sql statement.
//"UPDATE AUTOTRADE.RATE_ADVANCES SET TREASURY_RATE = '5.04'"
_oOracleCommand.ExecuteNonQuery();
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|