Quick question. I have the following SQL query I'm feeding into a string variable:
So I've done this (with Amp being set to Chr(38)Please Login or Register to view this content.
But every time I run the sub, I get:Please Login or Register to view this content.
Syntax error (missing operator) in query expression 'WHERE StatusID < 255 AND maskDebtorFlags & 256 != 0'
It's parsing it correctly clearly, as the ampersand is being substituted correctly, and I know the query works, because in SMSS it runs flawlessly. Does anyone have any idea why this would be doing this?
Bookmarks