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.
Thanks,
Roger
/* Test ATTACH two Databases SOC and Options and set one column in a
Table in SOC*/
DETACH Opt;
DETACH SOC;
ATTACH 'SOC.db' AS SOC;
ATTACH 'Options.db' AS Opt;
UPDATE Stocks SET bOption = 0;
SELECT DISTINCT Stocks.sStockSymbol, bOption FROM Stocks INNER JOIN
Options ON Stocks.sStockSymbol=Options.sStockSymbol ORDER BY
Stocks.sStockSymbol;
-- Why do I get 'SQL error: near "INNER": syntax error' at the end of
the previous output which is
-- fine except for the error message
-- Why doesn't the following UPDATE do anything? It has no effect and
provides no error messages.
UPDATE Stocks INNER JOIN Options ON Stocks.sStockSymbol =
Options.sStockSymbol SET Stocks.bOption = 1;
-- Note this is the same as the one above but does not provide an error
message.
SELECT DISTINCT Stocks.sStockSymbol, bOption FROM Stocks INNER JOIN
Options ON Stocks.sStockSymbol=Options.sStockSymbol ORDER BY
Stocks.sStockSymbol;
SELECT 'Total Number of Stocks: ',COUNT(*) FROM Stocks;
SELECT 'Number of Stocks with Options: ', COUNT(*) FROM Stocks WHERE
bOption = 1;
SELECT 'Number of Stocks without Options: ', COUNT(*) FROM Stocks WHERE
bOption = 0;
Also, .schema doesn't seem to do anything for ATTACHED databases, I
assume this is intentional.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------