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]
-----------------------------------------------------------------------------

Reply via email to