With Sybase (and, probably, MSSQL) you can query the @@trancount Transact SQL global variable. This will be 0 if there are no active transactions.
Michael On Fri, 2003-02-14 at 08:44, [EMAIL PROTECTED] wrote: > In DBD::Informix, there is an attribute for $dbh for ix_InTransaction which does >this for you. > > It is not standardized. > > -------Original Message------- > From: Roger Perttu <[EMAIL PROTECTED]> > > When I destroy my objects I would like to know if there are uncommitted > transactions. There shouldn't be any but I would like to know. Given > only a DBI database handle, is it possible to find out if there are > uncommitted transactions? If not, is there anything inside DBD-ODBC that > I could use? I didn't find anything in the docs. -- Michael Peppler Data Migrations, Inc. [EMAIL PROTECTED] http://www.mbay.net/~mpeppler Sybase T-SQL/OpenClient/OpenServer/C/Perl developer available for short or long term contract positions - http://www.mbay.net/~mpeppler/resume.html
