I am using a temporary table for some results, and I wanted to have the
rowids reset every time the table is used, so I drop the table if it is
already created, and then recreate it and fill it with results .
I thought I could use a SELECT along the lines of
SELECT 1 FROM sqlite_master WHERE (type = 'table') AND ('name =
tblTest') ;
But this doesn't seem to work. Is there another place to check for a
temporary table's existence (sqlite 2.8.13)?
--Keith
******************************************************
- I'm not a professional; I just get paid to do this.
- Good writing lets the reader think about 'what'
was written, not 'how' it was written.
******************************************************