by RICoder » Dec 22, 2001 @ 2:52am
ADO is funky like that. Mostly it requires strict adherence to STANDARD SQL. Meaning that you need to do stuff like using % as a wild card, even though some DBs use *. But, in other cases it doesn't care what you do, like you can use a terminating ; in the statement, even though only Access (that I know of) lets you do that. This is all fluff, but I wrote it anyway.<br><br>My point is, I guess, that standard SQL uses ' as string literal containers, NOT ". In fact the " will raise an error in some cases in ADO. It ALWAYS did for me when I tried to write some test code.<br><br>I don't know if there are any escape sequences in SQL...and I won't be in my office to ask our resident SQL guru until Thurs...If you still want to know then, let me know.
<iframe src="http://gamercard.xbox.com/RICoder.card" scrolling="no" frameBorder="0" height="140" width="204">RICoder</iframe>