On Wed, 27 Dec 2006, Joe Wilson wrote: > Search for these pragmas in the perl module. There might be a method > wrapping them. If there isn't, just execute these pragmas just after > opening the database.
Can't figure out how to execute them via Perl (yet). Interestingly, they only half work in the command-line version (I get Publisher.Name instead of P.Name): SQLite version 3.3.3 Enter ".help" for instructions sqlite> PRAGMA full_column_names=1; sqlite> PRAGMA short_column_names=0; sqlite> .header on sqlite> SELECT E.*, P.Name FROM Edition AS E, Publisher AS P WHERE E.GameID = 126 AND E.PublisherID = P.PublisherID ORDER BY E.Name, E.EditionID; E.EditionID|E.GameID|E.Name|E.PublisherID|E.Own|Publisher.Name 130|126|Roads & Boats|46||Splotter Spellen Thanks! -- Regards, joe Joe Casadonte [EMAIL PROTECTED] ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
