"Mike Marshall" <[EMAIL PROTECTED]> wrote: > Possibly a stupid question but I'm trying to do an attach and then query via > a single sqlite3_exec() statement. > > > > Is the following a valid use?
It is if the name of your database file is literally "dbpath". But from context, I suspect you are thinking that dbpath is some kind of variable that holds the database file name. That is incorrect. Substitute the name of your file (appropriately quoted) in place of where you have written "dbpath". > > > > sqlite3_exec(pDB,"ATTACH dbpath as universe;select * from othertable where > identifier IN (select identifier from > universe.identifierlist)",cbfn,NULL,NULL); > > > > Thanks in advance > > > > Mike ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------