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
Error using DAAB (January 2006) and AddInParameter
-
- Posts: 15
- Joined: Sat 05 Aug 2006 20:55
- Location: Brazil
-
- Posts: 15
- Joined: Sat 05 Aug 2006 20:55
- Location: Brazil
version 2.55
PostgreSQLDirect .NET 2.55 for VS 2005 and Windows Vista Business