Devart Forums

Hi,

Error call my Function in VS 2005 SP1, ex:

Database db = DatabaseFactory.CreateDatabase();
DbCommand cmd = db.GetStoredProcCommand("dclarion");
db.AddInParameter(cmd, "datax", DbType.Int32,75350);
string DataNova = (String)db.ExecuteScalar(cmd);
MessageBox.Show(DataNova);

Function in PostgreSQL 8.1.3

CREATE OR REPLACE FUNCTION dclarion(datax integer)
RETURNS character varying AS
$BODY$
select to_char(to_timestamp(($1 + 2378858)::varchar,'J'),'dd/mm/yyyy')
$BODY$
LANGUAGE 'sql' VOLATILE;


Debug Error: The DataRowVersion enumeration value, Default, is invalid.


Regards

What version of PostgreSQLDirect .NET do you use? We cannot reproduce any problem with beta version of our provider.

PostgreSQLDirect .NET 2.55 for VS 2005 and Windows Vista Business

Thanks to the received project I was able to reproduce the error mentioned on my Windows XP SP2.
Now we are investigating this problem. Look forward to the results.

This problem doesn't pertain to PostgreSQLDirect .NET because you do not use CoreLab.PostgreSql.EnterpriseLibrary.dll assembly.
For more information please read "Enterprise Library Data Access Block" topic of our help documentation.