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"
> initialize and create tables before I run the above query. I am also able to
> insert and update records in the tables in the in-memory database.
>
> My objective is to get a list of all tables in in-memory database. I am able
> to extract the tables list from SQLITE_MASTER though.
>
> Any ideas what could be going wrong?
>
> Thanks Vt
>
>
> --------------------------------- Do you Yahoo!? Yahoo! Finance: Get your
> refund fast by filing online
--
D. Richard Hipp -- [EMAIL PROTECTED] -- 704.948.4565
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
