Quoting Balazs Scheidler <[EMAIL PROTECTED]>: >> However, there is a PRAGMA table_info(table_name) which may come in >> handy at this point. We'd have to run a query using this PRAGMA >> whenever a query returns 0 rows to manually fix the column number in >> the (empty) libdbi result set. I'll check whether this is doable. > > Thanks, this sounds great. >
Not so great, unfortunately, as I figured the PRAGMA helps only in those cases where a single table is involved. I've asked the SQLite folks how they'd feel about making sqlite3_get_table() consistent in that it always returns the column headers even if the result set contains no rows. I'll have to see whether they agree to this change. If not, we'd have to rewrite the sqlite3 driver and use the low-level interface instead, as this would allow to analyze the prepared statement for column names and numbers. The good news is that the sqlite3 driver will eventually be in line with the other drivers in terms of column headers, one way or the other. I just can't tell when this is going to happen. regards, Markus -- Markus Hoenicka [EMAIL PROTECTED] (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de ------------------------------------------------------------------------- This SF.Net email is sponsored by the Moblin Your Move Developer's challenge Build the coolest Linux based applications with Moblin SDK & win great prizes Grand prize is a trip for two to an Open Source event anywhere in the world http://moblin-contest.org/redirect.php?banner_id=100&url=/ _______________________________________________ Libdbi-drivers-devel mailing list Libdbi-drivers-devel@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/libdbi-drivers-devel
