Hi all, I have a complex query that I want to run often and store the results to a temporary table. I'd like to compile a statement that looks something like:
CREATE TEMP TABLE ? AS SELECT * FROM data WHERE value = ?; so that I can have multiple threads accessing the results of the query in various temp tables simultaneously. The above gives me a parse error on the first ? for the temp table name. Is this a bug, or something that SQLite can't support? I have also tried compiling a simple query SELECT * FROM ?; which also gives a parse error. -Jeff ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
