"Markus Hoenicka" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > according to my experience, sqlite3_get_table() does not return a row > containing the column names and sets numcols to zero if a query > returns zero rows. This is in contrast to other database engines like > MySQL, PostgreSQL, and Oracle which return the column information even > if there are no rows in the result set. Is this a deliberate design > decision? Would there be a way to change it?
Don't use sqlite3_get_table. Use sqlite3_column_name, sqlite3_column_origin_name et al. You can call these on a prepared statement without even having to run it, so it doesn't matter whether it returns any rows or not. If all you want is to get column names of one table, see also PRAGMA table_info. Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
