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