Re: MSSQL: INSERT into table with TRIGGER

[Martin J. Evans]

 On 30/09/2010 17:56, Ludwig, Michael wrote:
Can you put print statements in your real trigger and setup
and odbc_err_handler to catch them so you can see what is
really running?
There is an example in t/20SqlServer.t included in the
DBD::ODBC test suite.
Thanks! That's a great help in debugging, which I didn't know
about. Still at the noob level in MSSQL.

   $dbh->{odbc_err_handler} = sub { print STDERR Dumper \...@_ };

And in SQL, simply:

   print @pubnr;

Michael

Please keep me up to date with how you get on Michael.

You can always find me on #dbi irc on magnet (not withstanding time 
differences).

Martin