A very minor efficiency note.
You can eliminate the runtime concatenation of your SQL strings by
letting the compiler do it at compile time. The compiler will
concatenate char[] constants that are separated by whitespace into a
single char[] constant. Replacing
sSQL = "UPDATE Stocks SET bOption=1 WHERE rowid IN ";
sSQL += "(SELECT Stocks.rowid FROM Stocks, Options ";
sSQL += "WHERE Stocks.sStockSymbol = Options.sStockSymbol); ";
with
sSQL = "UPDATE Stocks SET bOption=1 WHERE rowid IN "
"(SELECT Stocks.rowid FROM Stocks, Options "
"WHERE Stocks.sStockSymbol = Options.sStockSymbol); ";
eliminates two unnecessary calls to the string operator+= function. I
also think it looks better. :-)
HTH
Dennis Cote
Didn't know that, much appreciated. Thanks Dennis
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
