[GENERAL] Rowsaffected return from NonExecQuery with stored procedure problem

2009-07-13 Thread DonnaR
I'm using PostgreSQl NPGSQL and C#. Does the Rowsaffected return value work correctly when running a stored procedure to Insert, Update or Delete. According to the documentation, it should work with Insert, Update and Delete querys via ExecNonQuery, but can't find out if it should work if you do t

Re: [GENERAL] How do I 'include' a stored procedure in a SQL script file

2009-01-12 Thread DonnaR
Currently I'm using PGAdmin to create everything, but I need to create a script file to create the schemas and the tables to ultimately run outside of PGAdmin. Since I have triggers, I need to 'load in' the (long) stored/triggered procedures during this process (ie 'call or 'include' another file