Hi Guys, I don't know what to think about this one.
I have the following stored procedure defined: CREATE OR REPLACE FUNCTION insertemployeedepartment(int4, int4) RETURNS int4 AS 'INSERT INTO "EmployeeDepartment" VALUES($1, $2); SELECT 1;' LANGUAGE 'sql' VOLATILE; When I call this statement, using command.ExecuteNonQuery() I don't get any errors or exceptions thrown - but nothing gets inserted in the EmployeeDepartment table. If I call the function from pgAdmin it works as it should. I have several other stored procedures that are very simliar, but work fine. Any ideas? Thanks, Mike -- Be still like a mountain, and flow like a great river. --Lao Tse // This is my personal e-mail account // that I use for communication only. // Please send any e-mails with attachments // to [EMAIL PROTECTED] _______________________________________________ Npgsql-general mailing list Npgsql-general@gborg.postgresql.org http://gborg.postgresql.org/mailman/listinfo/npgsql-general