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. 
******************************************************

Reply via email to