On 5/22/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
I was playing with the problem a bit more last night, and found that some queries worked (for example the one specified on your example page: SELECT name FROM sqlite_master WHERE type='table' UNION ALL SELECT name FROM sqlite_temp_master WHERE type='table' ORDER BY name; - which apparantly is the same as the .tables command. However, when I try the query SELECT name FROM sqlite_master; it gives no results - even though a much more complex query with WHERE clauses gives some results. Any ideas on this?
Did you try "SELECT name FROM sqlite_temp_master"? Perhaps all your tables are temp tables? -- Nemanja Corlija <[EMAIL PROTECTED]>