I understand the pragma but was hoping for something like this const char *sqlite3_column_database_name(sqlite3_stmt*,int);
but with the sqlite3* and not a statement? Thanks again --- On Sat, 10/18/08, Igor Tandetnik <[EMAIL PROTECTED]> wrote: From: Igor Tandetnik <[EMAIL PROTECTED]> Subject: Re: [sqlite] database filename To: sqlite-users@sqlite.org Date: Saturday, October 18, 2008, 3:56 PM "Mike Johnston" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > Given a sqlite3 * database handle, is there a way to retrieve the > filename used to open the database? Run this statement on your handle: PRAGMA database_list; Note that there may be more than one file associated with the handle (see ATTACH statement). Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users