Re[2]: [Dbi-interbase-devel] I found why coredumps!!!

[Michael S. <mi...@ch...>]

Hello Edwin,

Monday, August 28, 2000, 5:03:55 PM, you wrote:

>> When  $dbh->trace(5) it cannot find ib_dateformat and dumps. When I
>> set pass it as attribute for $sth->prepare, it works.

EP> Could you send me your script that shows this problem?

All the genial are always simple.

==============================================================
use DBI;
use DBD::InterBase;
use strict;

my $db = "DBI:InterBase:database=/usr/interbase/price.gdb;host=localhost;ib_dialect=3;ib_charset=WIN1251";
my $user = 'WWW';
my $pass = 'www';

my $dbh = DBI->connect($db,$user,$pass,{'RaiseError' => 1}) or die DBI->errstr;
$dbh->trace(5);
my $sth = $dbh->prepare("SELECT * FROM USERS");
$sth->execute;
my $h = $sth->fetchrow_hashref;
1;
==============================================================

The table structure you have yet.

EP> I won't use the previous Tie::DBI script because it absolutely doesn't
EP> work.

Here's  the  diff  to Tie::DBI.pm. It got away from my head completely
that I patched it. The original module can't work at all.

EP> I personally never set the trace level to 5, because the most verbose
EP> debug message I print is at trace level 4.

Level 5 is just in case :-)

>> I think it would be the best if you set all the default attributes
>> just in the begin of "prepare", like this:

EP> Only if necessary. I let the attributes initialized to NULL, and set
EP> them only when any of the output fields needs them.

Maybe it's better...

Best regards,
 Michael                            mailto:mi...@ch...