On Wed, 27 Dec 2006, Joe Wilson wrote:
> my $dbh = DBI->connect($db);
> ...
> $dbh->do('PRAGMA full_column_names=1');
> $dbh->do('PRAGMA short_column_names=0');
Yeah, I eventually figured that out. This works as well:
my $dbh = DBI->connect($db);
...
my($sth) = $dbh->prepare('PRAGMA full_column_names=1');
$sth->execute;
At least insofar as the pragmas change in the sqlite engine itself.
But neither method has an effect on the output of the Perl code. He
has his own FullCol/ShortCol variables in select.c where he figures
out what to return. These are set via flags, which in turn are set in
pragma.c, assuming that the function sqlite3Pragma() is called
correctly. I'm thinking this is not a SQLite issue, and will contact
someone on the Perl side of things.
Thanks for the help!
--
Regards,
joe
Joe Casadonte
[EMAIL PROTECTED]
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
