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
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 ";
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]>
--
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 Sto
Stocks is a table in SOC and Options is a table in Options (Opt).
-
To unsubscribe, send email to [EMAIL PROTECTED]
-
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.
6 matches
Mail list logo