Re: [sqlite] tables in in-memory database

2004-02-11 Thread v t
Thanks Richard. It works now. Originally I tried using SQLITE_MASTER and it did not work so after searching this forum I found some info on SQLITE_TEMP_MASTER and tried that. I figured the reason why SQLITE_MASTER did not work originally is because I opened a new handle to the in-memory

Re: [sqlite] tables in in-memory database

2004-02-09 Thread D. Richard Hipp
v t wrote: > Hi > > When I execute the following query on a in-memory database, I get no results. > The query is " SELECT * FROM SQLITE_TEMP_MASTER WHERE type='table'". I ^^ Should be "SQLITE_MASTER" not "SQLITE_TEMP_MASTER" >