Re: Active statement handles mystery?



On Sun, Jul 15, 2007 at 03:55:43PM +1000, Owen wrote:

I have a script that operates on SQLite and SQLite2 that finished like;

$sth->finish; # Statement handle for $data_dbh
$sth_users_dbh->finish; # Statement handle for $users_dbh
$data_dbh->disconnect;
$users_dbh->disconnect;

__END__

After running successfully, it reports;

"closing dbh with active statement handles at dl_update line ....."

When I add

undef $sth;
undef $sth_users_dbh;

after the finish statements, the message is not reported.

I don't think it is important, but wonder if this is an oddity, or just something I am not doing?

Looks like a bug. Please report it.

Tim.
.



Relevant Pages

  • Active statement handles mystery?
    ... I have a script that operates on SQLite and SQLite2 that finished like; ... After running successfully, it reports; ... "closing dbh with active statement handles at dl_update line ....." ... undef $sth_users_dbh; ...
    (perl.dbi.users)
  • Re: [kde-linux] Kmail suggestions
    ... plus the blazing speed of sqlite db. ... then doing complex search strings threw 700,000 messages, would take ... be able to do reports... ... I was thinking of making my own database or index to search externally, ...
    (KDE)
  • Report Generator Suggestions
    ... I'm writing an MFC application that needs a ton of reports based on data stored in SQLite. ... There's not enough money for me to hand code all these reports in C++. ... The only thing I know about Crystal Reports is that I hated it back many years ago when it was included with VB classic. ...
    (microsoft.public.vc.mfc)
  • Re: How to check empty hash value properly?
    ... it reports that!exists as undef. ... use strict; ... use warnings; ...
    (perl.beginners)