SQL Server triggers (dbi:ODBC vs dbi:Sybase)

From: Fernando Donate (fernandodonate_at_yahoo.es)
Date: 08/12/04 

Date: 12 Aug 2004 08:15:44 -0700

Hello

If I use dbi:Sybase, when I insert a row (SQL Server 2000) in one
table from my perl script a trigger is 'trigged' and I can view the
trigger 'print' messages.

But If i use dbi:ODBC, i don't receive any output
Why? Any option at connect?

I need the output for debugging purposes (using odbc module)

Thanks.
Fernando

Relevant Pages

  • Re: Triggers and Flag bit
    ... I am a trigger that sets the DateModified field with getdateThen my perl script looks for certain range of modified dates and runs the necessary query. ... Should I create a trigger that will set the flag bit after any update? ... the timestamp solution seems feasible. ...
    (comp.databases.ms-sqlserver)
  • Re: Triggers and Flag bit
    ... Should I create a trigger that will set the flag bit after any update? ... Which version of SQL Server are you ... Your Perl script would issue a query, ...
    (comp.databases.ms-sqlserver)
  • Re: SQL Server triggers (dbi:ODBC vs dbi:Sybase)
    ... > table from my perl script a trigger is 'trigged' and I can view the ... > trigger 'print' messages. ... The message is almost certainly returned to the client (i.e. ... attribute/function to call or to set to get this output. ...
    (comp.lang.perl.modules)
  • Triggers and Flag bit
    ... I have a perl script (uses sql query) that will run if there is any update in the row. ... I am a trigger that sets the DateModified field with getdateThen my perl script looks for certain range of modified dates and runs the necessary query. ... Should I create a trigger that will set the flag bit after any update? ...
    (comp.databases.ms-sqlserver)
  • Re: Records not inserting...
    ... > I am totally new to SQL server. ... However, in a trigger, would I be ... test the effects of certain data modifications and to set conditions for ... UPDATE statements. ...
    (microsoft.public.sqlserver.odbc)