ORA-01843: Not a valid month + adonet + oledb provider
From: Wendell Rios (wendellrios_at_yahoo.com.br)
Date: 01/12/05
- Next message: Mona: "Re: Refreshing data in dataset"
- Previous message: SimonH: "Re: Making a generic data layer"
- Messages sorted by: [ date ] [ thread ]
Date: 12 Jan 2005 04:33:29 -0800
Hi all,
I'm getting this message when updating a oracle date field in
production.
That works fine in development, there is, I couldn't reproduce this
behavior.
The user reported he could updated one record, but when tried to do it
for the next record this error message started to appear.
The SQL Update statement is using parameters. I'm providding here a
snippet of my code:
If you have any answer or suggestion, please feel free to contact me
at NO_SPAMwendellrios@axen.com.br.
Thank you,
Wendell Rios.
//
// cmdUpdate
//
cmdUpdate.CommandText = @"UPDATE tblUser SET dtBalanceUpdate = ?,
idContainer = ?, nmUser = ?, vlBalance = ?, vlQuota = ? WHERE (idUser
= ?) ";
cmdUpdate.Connection = cn;
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("dtBalanceUpdate",
System.Data.OleDb.OleDbType.DBDate, 0, "dtBalanceUpdate"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("idContainer",
System.Data.OleDb.OleDbType.Integer, 0, "idContainer"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("nmUser",
System.Data.OleDb.OleDbType.VarWChar, 255, "nmUser"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("vlBalance",
System.Data.OleDb.OleDbType.Double, 0, "vlBalance"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("vlQuota",
System.Data.OleDb.OleDbType.Double, 0, "vlQuota"));
cmdUpdate.Parameters.Add(new
System.Data.OleDb.OleDbParameter("Original_idUser",
System.Data.OleDb.OleDbType.Integer, 0,
System.Data.ParameterDirection.Input, false, ((System.Byte)(0)),
((System.Byte)(0)), "idUser", System.Data.DataRowVersion.Original,
null));
- Next message: Mona: "Re: Refreshing data in dataset"
- Previous message: SimonH: "Re: Making a generic data layer"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
