[sqlite] How To Use ATTACH?

[Roger Miskowicz]

I know how to use ATTACH with sqlite3.exe but I am having problems using 
it in C++.  I am using a wrapper and what I am trying to do is 
illustrated by:

CppSQLite3DB db;
db.open("Stocks.db");

db.execDML("ATTACH   'Options.db' AS OPT;");

 sSQL = "UPDATE Stocks SET bOption=1 WHERE rowid IN ";
 sSQL += "(SELECT Stocks.rowid FROM Stocks, Options ";
 sSQL += "WHERE Stocks.sStockSymbol = Options.sStockSymbol); ";


  db.execDML(sSQL.c_str());

but this gives me an error saying table Options (in database file 
Options.db) is not available.

How do I get ATTACH to work in C++?

Thanks,
 Roger

-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------