Hello everyone,
I'm using the following code to update date [ oracle database ] its not raising any error, but its also not updating [ executeNonQuery returns 0 ]
public int updateMemoData(String memoID, String receiverID, String receiverName, String receiverDept, String startDate, String endDate, String issuerID, String issuerName, String issuerDept, String extDept, Boolean close)
{
int effected = 0;
comm.Parameters.Clear();
ds.Tables[0].Clear();
SQL = @"update memo_tasks
set STATUS = :STATUS,
RECEIVER_ID = :RECEIVER_ID,
RECEIVER_NAME = :RECEIVER_NAME,
RECEIVER_DEPT = :RECEIVER_DEPT,
START_DATE = :START_DATE,
END_DATE = :END_DATE,
ISSUER_ID = :ISSUER_ID,
ISSUER_NAME = :ISSUER_NAME,
ISSUER_DEPT = :ISSUER_DEPT,
EXTERNAL_DEPT = :EXTERNAL_DEPT
WHERE MEMO_ID = :MEMO_ID";if (close)
{
status = statusClose;
receiverID = receiverName = receiverDept = " ";
}
else
{
endDate = " ";
}
comm.Parameters.Add("MEMO_ID", memoID);
comm.Parameters.Add(
"STATUS", status);comm.Parameters.Add("RECEIVER_ID", receiverID);
comm.Parameters.Add(
"RECEIVER_NAME", receiverName);comm.Parameters.Add("RECEIVER_DEPT", receiverDept);
comm.Parameters.Add(
"START_DATE", startDate);comm.Parameters.Add("END_DATE", endDate);
comm.Parameters.Add(
"ISSUER_ID", issuerID);comm.Parameters.Add("ISSUER_NAME", issuerName);
comm.Parameters.Add(
"ISSUER_DEPT", issuerDept);comm.Parameters.Add("EXTERNAL_DEPT", extDept);
comm.Connection = oaConn;
comm.CommandText = SQL;
oaConn.Open();
effected = comm.ExecuteNonQuery();
oaConn.Close();
return effected;
}
any Ideas ?
thanks in advance.