Answer for:

SQL Statement in VB6 Code

Message 13 of 12

View entire thread
0 Votes

When you get done building the query string, display it (or put a breakpoint in and copy it's contents) and check it. It's not only easier to spot problems with quotation marks (unbalanced, missing, mismatched) but you can also paste the string into your favorite query client and "play" with it there until you have the correct query, then go back to make the fixes in your code.