Active statement handles mystery?




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?


TIA
.



Relevant Pages

  • Re: 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)
  • Re: Bind dhRichClient RS to VSView Reporting Edition
    ... ComponentOne to produce reports. ... However I am not having any success with the change to SQLite. ... Dim AdoRs as AdoDB.Recordset ...
    (microsoft.public.vb.database)
  • Re: Bind dhRichClient RS to VSView Reporting Edition
    ... ComponentOne to produce reports. ... However I am not having any success with the change to SQLite. ... used examples from VSView Help along with an example from Olaf of ... Dim AdoRs as AdoDB.Recordset ...
    (microsoft.public.vb.database)
  • 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)