I can't confirm that this is true for MS Access, but I'll take your word for it. How about a method that adds the single quotes for you? It meets your requirement of not wrapping 30 text strings in quotes.
or, if your data is in some kind of collection already:
James Merchny wrote:Sure...and I am doing that. But to wrap a bit of text in quotes thirty times just makes me wonder if there is not a better way.
Also, trying to debug the SQL statement is a challenge. I cannot find a way to examine the "updated" statement just prior to execution, other than drilling down through a coupld of layers of watches.
Yep. I hate that. A long time ago I found a library that could parse the prepared statement and show you the actual SQL you end up with.
Obviously, it is only for debugging as it kind of defeats the purpose of prepared statements.