Re: [sqlite] How to find table names referenced in the query, not in the result set

2012-08-20 Thread Pavel Ivanov
You can try to use authorizer (http://www.sqlite.org/c3ref/set_authorizer.html) although it seems to me SQLite won't inform you about access to table2 in the first query. Pavel On Mon, Aug 20, 2012 at 2:18 AM, Bishwa Shrestha wrote: > Hi, > > I am creating an sqlite3 interface to an existing da

Re: [sqlite] How to find table names referenced in the query, not in the result set

2012-08-20 Thread Simon Slavin
On 20 Aug 2012, at 10:18am, Bishwa Shrestha wrote: > Is there a way to get the table names that were referenced in the query > itself? I don't think so. Consider that you might do things like SELECT 1,2,3; SELECT (a.column1 + b.column1) FROM table1 AS a, table2 AS b; so it's quite possible

[sqlite] How to find table names referenced in the query, not in the result set

2012-08-20 Thread Bishwa Shrestha
Hi, I am creating an sqlite3 interface to an existing data model. For that purpose sqlite3 tables are dynamically loaded. I'm using /sqlite3_column_count/ and /sqlite3_column_table_name/ to load data into relevant tables only. Now, I am having problems with queries such as: SELECT a.column1