I'm trying to do an update with an WPF application through a Postgres Function but an exception is raised.. "FillinValues failed".. I don't really understand why.. Thnks for help.. Here is the C# Code:
public static int UpdateCategorie(int aID_CAT, string aINTITULE_CAT, string aDESCRIPTION_CAT, int? aPID_CAT)
{
using (OleDbConnection connex = new OleDbConnection(ConfigurationManager.ConnectionStrings["BMGDB"].ToString()))
{
OleDbCommand command = new OleDbCommand("UpdateCategorie", connex);
command.Parameters.Add("IDCategorie", OleDbType.VarChar).Value = aID_CAT;
command.Parameters.Add("Intitule", OleDbType.VarChar).Value = aINTITULE_CAT;
command.Parameters.Add("Description", OleDbType.VarChar).Value = aDESCRIPTION_CAT;
//command.Parameters.Add("PID", OleDbType.Integer).Value = aPID_CAT;
if (aPID_CAT == null)
{
command.Parameters.Add("PID", OleDbType.Integer).Value = null;
}
else
{
command.Parameters.Add("PID", OleDbType.Integer).Value = (int)aPID_CAT;
}
connex.Open();
int rows = command.ExecuteNonQuery(); //permet de retourner un entier indiquant le nbr de row affectées
connex.Close();
if (rows == 1)
{
return 1; // TODO - ShowDialog
}
else
{
return -1;// TODO - ShowDialog
}
}
}
Here's the Postgres function :
CREATE OR REPLACE FUNCTION UpdateCategorie(IDcategorie INTEGER, Intitule TEXT, Description TEXT开发者_运维百科, PID INTEGER) RETURNS VOID
AS $$
BEGIN
INSERT INTO CATEGORIE_HIST (ID_CAT, Intitule_CAT, Description_CAT, Modification_CAT, PID_CAT)
SELECT c.ID_CAT, c.Intitule_CAT, c.Description_CAT, c.Modification_CAT, PID_CAT
FROM CATEGORIE c
WHERE c.ID_CAT = $1
;
UPDATE CATEGORIE
SET Intitule_CAT = $2,
Description_CAT = $3,
PID_CAT = $4,
Modification_CAT = CURRENT_TIMESTAMP
WHERE ID_CAT = $1;
END;
$$
LANGUAGE plpgsql
;
Here's the stacktrace of Exception:
à System.Data.OleDb.OleDbCommand.ExecuteCommandTextErrorHandling(OleDbHResult hr)
à System.Data.OleDb.OleDbCommand.ExecuteCommandTextForMultpleResults(tagDBPARAMS dbParams, Object& executeResult)
à System.Data.OleDb.OleDbCommand.ExecuteCommandText(Object& executeResult)
à System.Data.OleDb.OleDbCommand.ExecuteCommand(CommandBehavior behavior, Object& executeResult)
à System.Data.OleDb.OleDbCommand.ExecuteReaderInternal(CommandBehavior behavior, String method)
à System.Data.OleDb.OleDbCommand.ExecuteNonQuery()
à BMG.DAL.Data_Provider.UpdateCategorie(Int32 aID_CAT, String aINTITULE_CAT, String aDESCRIPTION_CAT, Nullable`1 aPID_CAT) dans Projects\BMG\Code c#\BMG.BackOffice\BMG.DAL\Classes\Data_Provider.cs:ligne 399
à BMG.BLL.Classes.CATEGORIE_MANAGER.Update(Int32 aID_CAT, String aINTITULE_CAT, String aDESCRIPTION_CAT, Nullable1 aPID_CAT) dansProjects\BMG\Code \BMG.BLL\Classes\CATEGORIE_MANAGER.cs:ligne 128
Error seems to be in the oledbprovider.. Thanks for help!
Some quick googling turned up a few links to the EnterpriseDB forums from 2006 as well as this thread about the PgOleDb driver from January 2, 2011. Is there a reason you're not using a managed ADO.NET provider? Npgsql is an ADO.NET provider that is under active development.
精彩评论