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: > 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 created on a temporary table are also > temporary. Temporary tables and indices are stored in a separate file > distinct from the main database file. > > If a <database-name> is specified, then the table is created in the > named database. It is an error to specify both a <database-name> and > the TEMP keyword, unless the <database-name> is "temp". If no database > name is specified, and the TEMP keyword is not present, the table is > created in the main database. > > > It says that temp table is visible to the process it created, but how > about in this same process, I join a temp table with non-temp table?. > Since I am having Exception says: "no such table" when I do the join. > > Please help! > > Thank you in advance. > > > Mica >
