Hi Mike,
Thanks, that helped. Not that I needed to do that but it got me to
find the real problem... "Options.db was not in the current folder!"
which apparently is sufficient reason for its tables not being found.
Go figure! : )
Roger
[EMAIL PROTECTED] wrote:
I don't know your Wrapper, but try this:
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, OPT.Options ";
sSQL += "WHERE Stocks.sStockSymbol = OPT.Options.sStockSymbol); ";
db.execDML(sSQL.c_str());
Note that I prepended the database name assigned in the Attach statement in
your Update/Select statement.
Mike
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
