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
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"
>
2 matches
Mail list logo