Re: [sqlite] How To Use ATTACH?

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

[sqlite] How To Use ATTACH?

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 ";

Re: [sqlite] update inner join syntax

Thanks Richard, it worked perfectly. Roger [EMAIL PROTECTED] wrote: UPDATE stocks SET bOption=1 WHERE rowid IN (SELECT stocks.rowid FROM Stocks, Options WHERE Stocks.sStockSymbol = Options.sStockSymbol); -- D. Richard Hipp <[EMAIL PROTECTED]>

[sqlite] update inner join syntax

I am trying to do an update inner join, and have tried the following without success. Would someone please tell me the proper syntax for sqlite3? UPDATE Stocks, Stocks-- SQL error: near ",": syntax error INNER JOIN Options ON Stocks.sStockSymbol = Options.sStockSymbol SET

[sqlite] Re: Newbie Question

Stocks is a table in SOC and Options is a table in Options (Opt). - To unsubscribe, send email to [EMAIL PROTECTED] -

[sqlite] Newbie Question

I am having a problem updating a table in one of two attached databases. What I want to do is indicate in one table whether a name is listed in a table in the other attached database. I am sure it is simple but I can't get the UPDATE criteria to work properly. Any help would be appreciated.