in reply to Will an MS SQL db table trigger affect the value returned by scope_identity?

The problem is most likely that your SQL code returns more than one result set. Take a look at the DBD::Sybase docs, in particular handling of multiple result sets: http://search.cpan.org/~mewp/DBD-Sybase-1.14/Sybase.pm#Handling_Multiple_Result_Sets

Michael

  • Comment on Re: Will an MS SQL db table trigger affect the value returned by scope_identity?

In Section Seekers of Perl Wisdom