[sqlite] Re: Question about sqlite TEMP table

I forgot to mention, I do have two connections in ONE process, one of the connection is used to create those temp tables. but still, after temp table is created, none of the two connection can access to the Temp tables. On 7/22/05, Ming Qiang Lin <[EMAIL PROTECTED]> wrote: &g

[sqlite] Question about sqlite TEMP table

Hi All, Following is the sqlite CREATE TABLE definition: If the "TEMP" or "TEMPORARY" keyword occurs in between "CREATE" and "TABLE" then the table that is created is only visible to the process that opened the database and is automatically deleted when the database is closed. Any indices create