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] -----------------------------------------------------------------------------